Edit: I'm taking this to the General Forums because I think this may be done without a formula. Think outside the box.
The Goal: I need Columns B and C together (not merged but side by side) listed in the same order of Column A
I have three columns. Lets call them A, B and C.
Column A has a list of 30 students names in random order.
Column B has the same list of 30 students names in alphabetical order.
Column C has data about each student in Column B, next to it.
I need the data from B and C kept together, with the names sorted in the (random) order of Column A
Attachment 681746
Bookmarks