| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do i sort a list from cells by picking a specific letter? | Excel Discussion (Misc queries) | |||
| comparing names in a list | Excel Discussion (Misc queries) | |||
| Comparing 2 list | Excel Discussion (Misc queries) | |||
| Comparing Entries to a list | Excel Worksheet Functions | |||
| Excel sort by Fill Color by custom list sort | Excel Discussion (Misc queries) | |||
Linear Mode
