Lets say your items are in the range A1:A10, then in column B, cell B1 enter
=COUNTIF($A$1:$A$10,A1)

And drag down for the entire range. Then select both the ranges, go to Data
Sort based on column B ascending.


Mangesh



"Daniel - Sydney" <Daniel - wrote in
message ...
Hi

I have a spread sheet where there is a column with over 3000 cells,
there are 90 items, some appearing often and some only a few times.
Is there a way I can sort the column by the number of time an item
appears,
or to highlight how many time each item appears.

thanks

Daniel