software

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

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.
--
Theresequot;Eilishquot; skrev:

gt; Hi,
gt;
gt; I know it is fairly easy to sort a random list of high, low, medium that
gt; groups all the High's Medium's and LOw's together. but what if you had a list
gt; of
gt; Example 1:
gt; High
gt; High
gt; Medium
gt; Medium
gt; Low
gt; Low
gt;
gt; and wanted the following instead
gt; High
gt; Medium
gt; Low
gt; High
gt; Medium
gt; Low
gt;
gt; I have tried combinations of sorting but they group the values together,
gt; like in example 1 above.
gt;
gt; Any ideas greatly appreciated
gt; Eilish

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
lt;Datagt;lt;Sortgt;
Sort by:
Column B (ascending)
Column A (ascending)
Click the [OK] b utton

Does that help?

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

XL2002, WinXP-Proquot;Eilishquot; wrote:

gt; Hi,
gt;
gt; I know it is fairly easy to sort a random list of high, low, medium that
gt; groups all the High's Medium's and LOw's together. but what if you had a list
gt; of
gt; Example 1:
gt; High
gt; High
gt; Medium
gt; Medium
gt; Low
gt; Low
gt;
gt; and wanted the following instead
gt; High
gt; Medium
gt; Low
gt; High
gt; Medium
gt; Low
gt;
gt; I have tried combinations of sorting but they group the values together,
gt; like in example 1 above.
gt;
gt; Any ideas greatly appreciated
gt; Eilish

Hi Therese,

Thanks for the quick reply - I assigned values, 1,2,3 etc to each
High,Medium and Low and then sorted by this extra column by using my custom
list and it works a treat!

This is so neat and quick i reckon it will do the job nicely!

Cheers
Eilishquot;Theresequot; wrote:

gt; Hi
gt; Here is a solution of a somewhat more creative kind. I am sure you can make
gt; it a whole lot easier. But I'd insert an extra column next to, give that
gt; column numbers and then sort by this new column. After that I'd hide the
gt; extra column so that it isn't visible.
gt; Hope it's in use until you find a better way.
gt; --
gt; Therese
gt;
gt;
gt; quot;Eilishquot; skrev:
gt;
gt; gt; Hi,
gt; gt;
gt; gt; I know it is fairly easy to sort a random list of high, low, medium that
gt; gt; groups all the High's Medium's and LOw's together. but what if you had a list
gt; gt; of
gt; gt; Example 1:
gt; gt; High
gt; gt; High
gt; gt; Medium
gt; gt; Medium
gt; gt; Low
gt; gt; Low
gt; gt;
gt; gt; and wanted the following instead
gt; gt; High
gt; gt; Medium
gt; gt; Low
gt; gt; High
gt; gt; Medium
gt; gt; Low
gt; gt;
gt; gt; I have tried combinations of sorting but they group the values together,
gt; gt; like in example 1 above.
gt; gt;
gt; gt; Any ideas greatly appreciated
gt; gt; Eilish

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

quot;Ron Coderrequot; wrote:

gt; Try something like this:
gt;
gt; With your list of values in Col_A, beginning in A1
gt;
gt; B1: =COUNTIF(A$1:A1,A1)
gt; Copy down as far as needed
gt;
gt; Select both columns of data
gt; lt;Datagt;lt;Sortgt;
gt; Sort by:
gt; Column B (ascending)
gt; Column A (ascending)
gt; Click the [OK] b utton
gt;
gt; Does that help?
gt;
gt; ***********
gt; Regards,
gt; Ron
gt;
gt; XL2002, WinXP-Pro
gt;
gt;
gt; quot;Eilishquot; wrote:
gt;
gt; gt; Hi,
gt; gt;
gt; gt; I know it is fairly easy to sort a random list of high, low, medium that
gt; gt; groups all the High's Medium's and LOw's together. but what if you had a list
gt; gt; of
gt; gt; Example 1:
gt; gt; High
gt; gt; High
gt; gt; Medium
gt; gt; Medium
gt; gt; Low
gt; gt; Low
gt; gt;
gt; gt; and wanted the following instead
gt; gt; High
gt; gt; Medium
gt; gt; Low
gt; gt; High
gt; gt; Medium
gt; gt; Low
gt; gt;
gt; gt; I have tried combinations of sorting but they group the values together,
gt; gt; like in example 1 above.
gt; gt;
gt; gt; Any ideas greatly appreciated
gt; gt; Eilish

Fantastic Ellish :0)
--
Theresequot;Eilishquot; skrev:

gt; Hi Ron,
gt;
gt; Thanks for the quick response, I inserted the formula and it works great but
gt; only if I don't sort by Col A only col b using my custom sort but it does
gt; work and thats what I needed.
gt;
gt; Your answer gives me a quick way of entering numbers and Therese's
gt; suggestion of hiding this field makes it appear that it is more sophisticated!
gt;
gt; Many Thanks to all for suggestions
gt;
gt; quot;Ron Coderrequot; wrote:
gt;
gt; gt; Try something like this:
gt; gt;
gt; gt; With your list of values in Col_A, beginning in A1
gt; gt;
gt; gt; B1: =COUNTIF(A$1:A1,A1)
gt; gt; Copy down as far as needed
gt; gt;
gt; gt; Select both columns of data
gt; gt; lt;Datagt;lt;Sortgt;
gt; gt; Sort by:
gt; gt; Column B (ascending)
gt; gt; Column A (ascending)
gt; gt; Click the [OK] b utton
gt; gt;
gt; gt; Does that help?
gt; gt;
gt; gt; ***********
gt; gt; Regards,
gt; gt; Ron
gt; gt;
gt; gt; XL2002, WinXP-Pro
gt; gt;
gt; gt;
gt; gt; quot;Eilishquot; wrote:
gt; gt;
gt; gt; gt; Hi,
gt; gt; gt;
gt; gt; gt; I know it is fairly easy to sort a random list of high, low, medium that
gt; gt; gt; groups all the High's Medium's and LOw's together. but what if you had a list
gt; gt; gt; of
gt; gt; gt; Example 1:
gt; gt; gt; High
gt; gt; gt; High
gt; gt; gt; Medium
gt; gt; gt; Medium
gt; gt; gt; Low
gt; gt; gt; Low
gt; gt; gt;
gt; gt; gt; and wanted the following instead
gt; gt; gt; High
gt; gt; gt; Medium
gt; gt; gt; Low
gt; gt; gt; High
gt; gt; gt; Medium
gt; gt; gt; Low
gt; gt; gt;
gt; gt; gt; I have tried combinations of sorting but they group the values together,
gt; gt; gt; like in example 1 above.
gt; gt; gt;
gt; gt; gt; Any ideas greatly appreciated
gt; gt; gt; Eilish

But now I have a problem...I can't pose a question!!! I am logged in but can
only answer.
--
Theresequot;Eilishquot; skrev:

gt; Hi,
gt;
gt; I know it is fairly easy to sort a random list of high, low, medium that
gt; groups all the High's Medium's and LOw's together. but what if you had a list
gt; of
gt; Example 1:
gt; High
gt; High
gt; Medium
gt; Medium
gt; Low
gt; Low
gt;
gt; and wanted the following instead
gt; High
gt; Medium
gt; Low
gt; High
gt; Medium
gt; Low
gt;
gt; I have tried combinations of sorting but they group the values together,
gt; like in example 1 above.
gt;
gt; Any ideas greatly appreciated
gt; Eilish