Great,

thank for the fast reply

Daniel

"Rowan" wrote:

Hi Daniel

Assuming your data is in A2:A3000 then in B2 enter =COUNTIF($A$2:$A$3000,A2)
and copy down. This will give you the count for each item. You can then sort
by column B.

Hope this helps
Rowan

"Daniel - Sydney" wrote:

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