Hi Ron,

Thanks for the quick response, I inserted the formula and it works great but
only if I don't sort by Col A only col b using my custom sort but it does
work and thats what I needed.

Your answer gives me a quick way of entering numbers and Therese's
suggestion of hiding this field makes it appear that it is more sophisticated!

Many Thanks to all for suggestions

"Ron Coderre" wrote:

Try something like this:

With your list of values in Col_A, beginning in A1

B1: =COUNTIF(A$1:A1,A1)
Copy down as far as needed

Select both columns of data
<Data<Sort
Sort by:
Column B (ascending)
Column A (ascending)
Click the [OK] b utton

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro


"Eilish" wrote:

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