Sorting a table

termeric

Board Regular
Joined
Jun 21, 2005
Messages
245
hello,

i have a spread sheet with 8 coulmns, 4 represent different benefits, and 4 represent the cost of said benefits. its set up so that each column alternates between a benefit and cost.

the problem that i have is that there is no logic as to what benefit is in what column, so medical could be in column A for someone and column E for someone else.

is there any way to sort the list so that medical is in column A with its coresponding cost in column B, Dental in column C with its cost in D and so on.


thanks,
 

Some videos you may like

Excel Facts

Which Excel functions can ignore hidden rows?
The SUBTOTAL and AGGREGATE functions ignore hidden rows. AGGREGATE can also exclude error cells and more.

Watch MrExcel Video

Forum statistics

Threads
1,114,403
Messages
5,547,750
Members
410,811
Latest member
adustin42
Top