| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Can I sort a list to match a previously existing order?
I have a list of numbers that corresponds to a list of data (for example, a
list of test grades by student name). Is it possible to sort a second list of numbers (associated with the same data) to match the order of the first list? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Can I sort a list to match a previously existing order?
From what you've written, it sounds like a vLookup function will do the trick.
HTH, -- Gary Brown If this post was helpful, please click the ''Yes'' button next to ''Was this Post Helpfull to you?''. "MirCS" wrote: I have a list of numbers that corresponds to a list of data (for example, a list of test grades by student name). Is it possible to sort a second list of numbers (associated with the same data) to match the order of the first list? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Default Sort Order | Excel Worksheet Functions | |||
| How do I sort multiple worksheet pages to list in numerical order? | Excel Worksheet Functions | |||
| Sort with a List | Excel Worksheet Functions | |||
| Excel sort by Fill Color by custom list sort | Excel Discussion (Misc queries) | |||
| sort list of players by team from player list on separate sheet | Excel Worksheet Functions | |||
Linear Mode
