Sorting 4 columns cohesively?

Is there a code or some way for me to sort 4 columns together? I want to sort a list of employees and for each employee theres a column with their Lost Business, customer satisfaction, and two more columns. I want to sort all the columns at the same time so that the best employees overall will go to the top of the list and the worst ones will be at the bottom. Whenever I use the sorting feature it does each column independant of the others so everytime I sort a new column it just moves around the last one I sorted. Any solution?

I've tried that, but it seems to not put all the best values for each column at the top. It sorts the first column then sorts the second column which just cancels out the sorting done in the first column, and then the third one cancels out the first two columns and so on.

You can specify three sort criteria to versions of Excel up to 2003. Sort from the most relevant parameter to the least.

The secondary and tertiary critera don't cancel the higher-level criteria; they sub-sort within equal values.

Originally Posted by shg

You can specify three sort criteria to versions of Excel up to 2003. Sort from the most relevant parameter to the least.

The secondary and tertiary critera don't cancel the higher-level criteria; they sub-sort within equal values.

what if all parameters are equally important?

It sounds like you might want to assign a value to each of the 4 criteria, and add these up in a new column, then sort on the new column.

HTH

Jason