Hi everyone ,
[BPlease see attachment for better understanding[/B]
Here's my problem i have an excel sheet with appoxiamtely 13,000 entries and i need to compare 2 columns versus two other columns within the same excel sheet by looking for the same entry.
So i want to have something that will look at the name in Column H and then look for that name in Column C and then copy that column( C) along with its value in Column E to the newly created Columns K and L, while including column H and I's values, respectively.... duplicates are fine. i don't want to remove that.
What i am looking for: i am looking for either macro (preferably) or a formula that will accomplish this task.
Here is an example of what it looks like for better understanding
* Column H and I are the orginal two columns and Column C and E are the columns we are looking at to find duplicate names from Column H
* Column K and L would be where i want the new data to be shown
This is what i have:
Column C Column E Column H Column I Column K Column L
Peter Parker 154.90 Henry Rodney 214.67
Peter Parker 234.02 Nate Robinson 456.56
Nate Robinson 124.34 Dale Williams 345.36
John Smith 312.42 Roberto Stockton 789.45
Janet Anderson 524.14 John Smith 568.48
Dale Williams 344.42 Peter Parker 154.90
Dale Williams 344.42 Janet Anderson 782.64
Roberto Stockton 258.24
Henry Rodney 214.67
Henry Rodney 214.67
Henry Rodney 412.44
This is what i want it to look like:
Column C Column E Column H Column I Column K Column L
Peter Parker 154.9 Henry Rodney 214.67 Henry Rodney 214.67
Peter Parker 234.02 Nate Robinson 456.56 Henry Rodney 214.67
Nate Robinson 124.34 Dale Williams 345.36 Henry Rodney 214.67
John Smith 312.42 Roberto Stockton 789.45 Henry Rodney 412.44
Janet Anderson 524.14 John Smith 568.48 Nate Robinson 456.56
Dale Williams 344.42 Peter Parker 154.9 Nate Robinson 124.34
Dale Williams 344.42 Janet Anderson 782.64 Dale Williams 345.36
Roberto Stockton 258.24 Dale Williams 344.42
Henry Rodney 214.67 Dale Williams 344.42
Henry Rodney 214.67 Roberto Stockton 789.45
Henry Rodney 412.44 Roberto Stockton 258.24
John Smith 568.48
John Smith 312.42
Peter Parker 154.9
Peter Parker 154.9
Peter Parker 234.02
Janet Anderson 782.64
Janet Anderson 524.14
Thank you, so much in advance
Bookmarks