Thanks Hiroto.
To make this work, lets assume the following for a test case: I have three lists of 500 entries each I wish to merge and sort per my requirements. (Actually I have 120 lists of 350 entries each, but I see that Applwworks is limted to 16000 rows. I'll have to do it in batches.)
I make a new doc to paste all the data into that is 1500 rows and 6 colums wide? I paste all three lists into column A and do an alphabetic sort, then I see all my duplicates all in a row throughout that new 1500 line list.
To make the formulas for columns B, C, and D, do I do it with these larger numbers instead?
B1 =1
B2 =IF(A2=A1,B1+1,1)
..
B1500 =IF(A1500=A1499,B1499+1,1)
C1 =IF(B1<B2,"",A1)
..
C1500 =IF(B21500<B1501,"",A1500)
D1 =IF(B1<B2,"",B1)
..
D1500 =IF(B1500<1501,"",B1500)
My custom spread sheet skills are a bit rusty, do I enter into these cells as follows:
B1 =1
B2 =IF(A2=A1,B1+1,1)
B1500 =IF(A1500=A1499,B1499+1,1)
and so forth for the C and D cells?
How does the spread sheet calculate, or how do I start the process once I make this new document?