View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Roadtripper902902V3V Roadtripper902902V3V is offline
external usenet poster
 
Posts: 7
Default Sort according to most repeated entries

Hello,
How can I sort a column based on repetition.

For example,

Anna
Bob
Bob
Bob
Bob
Chuck
Chuck
Tiger
Tiger
Tiger
Tiger
Tiger
Tiger
Tiger
Sam
Sam
Sam



will be:

Tiger
Tiger
Tiger
Tiger
Tiger
Tiger
Tiger
Bob
Bob
Bob
Bob
Sam
Sam
Sam
Chuck
Chuck
Anna