Thread: Fomula
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Steve
 
Posts: n/a
Default Fomula

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