Sort a list by comparing two cells.
 

I am trying to make a priorities list as part of an excel daily task sheet.
Basically I want to list my things to do today in one column. In the next
column I will put an A,B,C,D,E based on importance. In the next column I will
rank the item using 1,2,3,4,5. I would like to be able to then have the items
sort by the letter value and then the number value, therefore all the A's
would be first in descending order followed by the B's. Any suggestions?

Sort a list by comparing two cells.
 

After inputting all your data, highlight it and go to data\sort and sort
according to the columns/headers you want. Good luck!

-Chad

"MattB" wrote:

I am trying to make a priorities list as part of an excel daily task sheet.
Basically I want to list my things to do today in one column. In the next
column I will put an A,B,C,D,E based on importance. In the next column I will
rank the item using 1,2,3,4,5. I would like to be able to then have the items
sort by the letter value and then the number value, therefore all the A's
would be first in descending order followed by the B's. Any suggestions?