Sort Excel rows two at a time

May 4, 2009 at 17:30:12
Specs: Windows XP

I am looking for a way to sort rows in a way that two rows correspond to each other and that two columns are the same.

For example, let's say we have this order:


That means 5 corresponds to Printing, 8 corresponds to Payroll and 3 corresponds to Escrow

If I have the following case:

Printing Escrow
5 3
Payroll Printing
8 5
Escrow Payroll
3 8

Is there any way to sort column two so its exactly the same as column 1? The numbers each correspond to each task. Thanks.

See More: Sort Excel rows two at a time

Report •

May 4, 2009 at 21:55:06
If Column 2 is going to look exactly the same as Column 1 why not just use a simple = formula?


Obviously there must be more to this than just a sort.

Report •
Related Solutions

Ask Question