use a formula such as
=COUNTIF($A$1:$A$30000,A1)
and fill this down a help column
then sort the two columns by the second column
30000 is a large selection
it may pay to take a back up first
--
Greetings from New Zealand
Bill K


"Steve" wrote in message
...
I am currrently working on a project that includes over 30000 entries. The
thing is, I do not need to do anything with any entry that occurs once.
What
I am looking for is a fomula that will take a colum and sort it by entries
that occur more that once.
For ex. If I had 5
5
5
6
7
7
8
9
9
9
I want in order of most to least, everything that occurs more than once.
If
this works right everything that occurs once will be at the bottom. It is
basically a sort that does not include the once occuring entries.

any help is welcome