Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
match up columns and move data
I have 2 columns with numbers in them.(they are much bigger than my
examples). All numbers in column B exist in column A but not all numbers in column A exist in column B. What I need to do is match up B with A. So I need to find the number 2 in column A and then move the 2 down in column B so it aligns with the 2 in column A. Is there a quick and easy way to do this? I have listed my desired result below. A B 1 2 2 4 3 5 4 8 5 6 7 8 Desired result A B 1 2 2 3 4 4 5 5 6 7 8 8 ngg -- ngg |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
move two columns of data to four columns | Excel Discussion (Misc queries) | |||
1 file- multiple headers, move columns to match first header | Excel Programming | |||
Help in code Steve G wrote to move data from 4 columns to 21 columns | Excel Programming | |||
Match and Move Data in 2 Spreadsheets | Excel Discussion (Misc queries) | |||
If Cell Contents Don't Match, Move All Data Down One Row | Excel Programming |