LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
 
Posts: n/a
Default Deleting specific records from a column

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Lookup Table Dilemma Karen Excel Worksheet Functions 2 June 10th 05 08:22 PM
networkdays() problem when deleting row or column Jason Excel Worksheet Functions 0 April 8th 05 11:09 PM
Number of records by Month that meet a specific requirement Keith Brown Excel Worksheet Functions 1 February 5th 05 05:42 PM
Finding and Deleting duplicates in a column Brian Excel Worksheet Functions 3 February 5th 05 02:19 PM
In column A I have duplicate records. How do I tag an unique reco. Tian Excel Discussion (Misc queries) 2 January 13th 05 07:37 PM


All times are GMT +1. The time now is 05:08 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"