| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Locate data from 1 column in another
Assuming your data starts from A1 use the below formula in B1...which will
return "Present" if present in colD. =IF(TRIM(A1)=D:D,"Present","") If this post helps click Yes --------------- Jacob Skaria "Shaz" wrote: 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? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Locate data from 1 column in another
In E2=IF(COUNTIF(D:D,A2),"present","")
Auto Filter the blanks in Column E and delete "Shaz" wrote: 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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Locate duplicates in column A, then, delete the row | Excel Worksheet Functions | |||
| Locate last cell in column | Excel Discussion (Misc queries) | |||
| Locate a specific row or column | New Users to Excel | |||
| How to locate the Row and Column of an Active Cell | Excel Discussion (Misc queries) | |||
| Locate max value of one column based on criteria in another colum | Excel Worksheet Functions | |||
Linear Mode
