Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Swapping Columns
I have a list of vehicles with license plate and key number, all having there
own column. Is there a formula where B & C, F & G, J & K will swap places? (would like to see key, plate, vehicle, assigned, ect..) B = Plate # C = Key # D = Vehicle E = Where vehicle is assigned F = Plate # G = Key # H = Vehicle I = Where vehicle is assigned J = Plate # K = Key # L = Vehicle M = Where vehicle is assigned Thank you in advance for the help. Penny |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Swapping Rows & Columns | Excel Discussion (Misc queries) | |||
swapping column info between 2 columns | Excel Worksheet Functions | |||
swapping data from 2 separate columns | Excel Discussion (Misc queries) | |||
swapping columns?? | Excel Discussion (Misc queries) | |||
Swapping rows and columns | Excel Worksheet Functions |