I need to do the following sort and have not figured out a way:

First sort by Column B ...ascending.
Then compare Columns E, G, and I for highest value and sort Ascending.

To be clear.....whatever is the lowest number in those three columns...it
sorts first...regardless of what the other fields say.

Your help is Appreciated!!!!!

If I understand correctly, maybe you could use a helper column. In an empty
column (let's say J2) enter:

=MAX(E2,G2,I2)

and copy down. Then sort your data using column B as the primary key and
column J (helper column) as the secondary key. Then delete column J (if you
like).


"Terri" wrote:

I need to do the following sort and have not figured out a way:

First sort by Column B ...ascending.
Then compare Columns E, G, and I for highest value and sort Ascending.

To be clear.....whatever is the lowest number in those three columns...it
sorts first...regardless of what the other fields say.

Your help is Appreciated!!!!!