See this sample file:

http://cjoint.com/?kmd6wEsiac

Biff

"Max" wrote in message
...
Venturing some thoughts ..

Assuming source data running in A1 down, and what's required is an
auto-ascending sort of only the unique source data items in col F, with a
corresponding occurences count in col G

Put in E1:
=IF(A1="","",IF(COUNTIF($A$1:A1,A1)1,"",IF(ISNUMB ER(A1+0),A1+ROW()/10^10,IF(ISTEXT(A1),CODE(LEFT(A1))+ROW()*10^10))))

Put in G1:
=IF(ROW()COUNT(E:E),"",INDEX(A:A,MATCH(SMALL(E:E, ROW()),E:E,0)))

Put in H1:
=IF(F1="","",COUNTIF(A:A,F1))

Then select E1:H1, copy down 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 ascending order*, while col G returns the corresponding count of
the uniques' occurences.
*Numbers (either real or text numbers) will be sorted ahead of alphas
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"gmisi" wrote:
I wish I could come up with a combination of functions to automate the
sorting (in ascending or desc. order) columnA (the lenght is different
on
each sheet) containing multiple text and/or number values (even blank
ones)
so, that in colF will be the sorted list of unique values and colG will
show
how many times this value figures in the unsorted list ---- but I can't,
so I
ask for your kind help.

Thanks in advance