Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I have a large amount of data in two seperate sets with one common column
(account #'s). I would like to pull one figure from the second set into my first set if the common column matches. However, there are more account #'s in the second set and I cannot just sort them by account # and put them on the same row. What is the easiest (and fastest - no cut and paste!) way to do this? Thank you!! Example: Set 1: Col A Name Col B Acct # Col C 12/31/03 Figures Set 2: Col A Name Col B Acct # Col C 2/28/07 Figures DESIRED SET: Col A Name Col B Acct # Col C 12/31/03 Figures Col D 2/28/07 Figures |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Combining Data | Excel Discussion (Misc queries) | |||
Combining data | Excel Discussion (Misc queries) | |||
combining multiple rows of data into one single row of data | Excel Worksheet Functions | |||
Combining Data | Excel Discussion (Misc queries) | |||
Combining Data | Excel Discussion (Misc queries) |