ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Can I sort a list to match a previously existing order? (https://www.excelbanter.com/excel-worksheet-functions/113922-can-i-sort-list-match-previously-existing-order.html)

MirCS

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?

Gary L Brown

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?



All times are GMT +1. The time now is 12:52 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com