LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 27
Default Locate data from 1 column in another

I have 500 email addresses in column D and 13,000 in column A. Now i want to
delete all of the column A except the ones which are also in column D.

in other words I want to locate 500 contacts within our entire database of
13,000 checking it on email address. Can any body help please?
 
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
Locate duplicates in column A, then, delete the row Gary Excel Worksheet Functions 3 June 19th 08 01:54 AM
Locate last cell in column Sloth Excel Discussion (Misc queries) 8 January 24th 08 05:36 PM
Locate a specific row or column clara New Users to Excel 2 March 22nd 07 04:45 PM
How to locate the Row and Column of an Active Cell Fred Excel Discussion (Misc queries) 1 December 7th 05 05:55 PM
Locate max value of one column based on criteria in another colum JDay01 Excel Worksheet Functions 2 September 1st 05 06:47 PM


All times are GMT +1. The time now is 12:49 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"