Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Find Matching Data Two Columns
I have data that I am pasting into columns A and B. C is an empty column. I have existing data in columns D, E, and F. I would like to find the common data in columns B and D, and add the matching data to empty Col C plus bring along all associated data from other columns. For Example: Pasted Data Cols A - B Existing Data Cols D - F Col A = BDAY | B = NAME | C= EMPTY | D = NAME | E = AGE | F = AREA-CODE 5th Jim B Scot C 22 413 18th Ron J Ted F 31 615 21st Scot C Jim B 45 213 AFTER SORTING: Col A = BDAY | B = NAME | C= EMPTY | D = NAME | E = AGE | F = AREA-CODE 5th Jim B Jim B Jim B 45 213 21st Scot C Scot C Scot C 22 413 I tried using a formula I found on the Microsoft web site but it worked and worked and never produced results. Cols A,B will contain several hundred rows of data while Col D - F will contain tens of thousands of rows of data. If you could show me a formula or macro to do this I would really appreciate it. Gilly |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Example Repost
I'm hoping this example is clearer than the last :)
BDAY |NAME | EMPTY |NAME | AGE |AREA-CODE 5th Jim B Scot C 22 413 18th Ron J Ted F 31 615 21st Scot C Jim B 45 213 AFTER SORTING: BDAY | NAME | EMPTY | NAME | AGE | AREA-CODE 5th Jim B Jim B Jim B 45 213 21st Scot C Scot C Scot C 22 413 Gilly |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
sorting 2 colums of numbers and incremening them down | Excel Discussion (Misc queries) | |||
Need to Improve Code Copying/Pasting Between Workbooks | Excel Discussion (Misc queries) | |||
Find data in columns, then place in rows | Excel Worksheet Functions | |||
How to take matching data from 2 columns and put in the same row? | New Users to Excel | |||
Pulling data from 1 sheet to another | Excel Worksheet Functions |