Sorry, some typos in the preceding response ..
Lines
Put in G1: ..
Put in H1: ..
Then select E1:H1 ...
should read as
Put in F1: ..
Put in G1: ..
Then select E1:G1 ...
And for an auto-descending sort of only the unique source data items in col
F ..
try these ..
Put instead in E1:
=IF(A1="","",IF(COUNTIF($A$1:A1,A1)1,"",IF(ISNUMB ER(A1+0),A1+0,IF(ISTEXT(A1),CODE(LEFT(A1))*10^10-ROW()))))
Put instead in F1:
=IF(ROW()COUNT(E:E),"",INDEX(A:A,MATCH(LARGE(E:E, ROW()),E:E,0)))
(no change to G1's formula)
Then just copy E1:G1 down as before to cover the max expected extent of
source data in col A. Hide away col E. Col F will yield the list of uniques
from col A,
sorted in descending order*, while col G returns the corresponding count of
the uniques' occurences.
*Alphas will be sorted ahead of numbers (either real or text numbers)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---