Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
Hi All
I have a little problem. I have two sets of records - let's say for the purpose of this exercise they are titled "a" and "b". The record sets differ but do have many matching records. My objective is to extract all the "b" records that match up with an equivalent record from the "a" column. The final record set will have these "b" records and their matching "a" records deleted from it. Example Column a Column b Final column earth earth sky sky grain fire fire metal air rain rain air heat Hope I've explained it well enough Any thoughts would be appreciated. Cheers, Mike |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Lookup Table Dilemma | Excel Worksheet Functions | |||
networkdays() problem when deleting row or column | Excel Worksheet Functions | |||
Number of records by Month that meet a specific requirement | Excel Worksheet Functions | |||
Finding and Deleting duplicates in a column | Excel Worksheet Functions | |||
In column A I have duplicate records. How do I tag an unique reco. | Excel Discussion (Misc queries) |