Hi
Here is a solution of a somewhat more creative kind. I am sure you can make
it a whole lot easier. But I'd insert an extra column next to, give that
column numbers and then sort by this new column. After that I'd hide the
extra column so that it isn't visible.
Hope it's in use until you find a better way.
--
Therese


"Eilish" skrev:

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