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

Hi,

I know it is fairly easy to sort a random list of high, low, medium that
groups all the High's Medium's and LOw's together. but what if you had a list
of
Example 1:
High
High
Medium
Medium
Low
Low

and wanted the following instead
High
Medium
Low
High
Medium
Low

I have tried combinations of sorting but they group the values together,
like in example 1 above.

Any ideas greatly appreciated
Eilish