LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 38
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Swapping Rows & Columns Alan Excel Discussion (Misc queries) 2 August 14th 08 08:38 PM
swapping column info between 2 columns rosy Excel Worksheet Functions 1 September 22nd 06 06:49 AM
swapping data from 2 separate columns Johnny D Excel Discussion (Misc queries) 1 February 15th 06 11:40 PM
swapping columns?? Johnny D Excel Discussion (Misc queries) 0 February 15th 06 07:13 PM
Swapping rows and columns Dorn Excel Worksheet Functions 2 November 11th 05 09:07 PM


All times are GMT +1. The time now is 11:33 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"