| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
duplicates with a twist
I have two lists of e-mail addresses - I want to compare them (I've got them
on the same spreadsheet right now) if column "a" has an e-mail address that is in column" b" I want to delete column "a's" cell. Is this possible? Thanks |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
duplicates with a twist
justche wrote:
I have two lists of e-mail addresses - I want to compare them (I've got them on the same spreadsheet right now) if column "a" has an e-mail address that is in column" b" I want to delete column "a's" cell. Is this possible? Thanks One way... say 100 email addresses in column A (rows 1 to 100), and 200 in column B (rows 1 to 200), then in the next available column fill the following formula down to row 100... =IF(COUNTIF($B$1:$B$200,A1)0,"",A1) Copy those results then paste special values over the top of column A, then sort to remove blanks. Ken Johnson |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
duplicates with a twist
WOW - worked hours on that, and yours worked instantly - thanks very much for
the response. Ken Johnson wrote: I have two lists of e-mail addresses - I want to compare them (I've got them on the same spreadsheet right now) if column "a" has an e-mail address that is in column" b" I want to delete column "a's" cell. Is this possible? Thanks One way... say 100 email addresses in column A (rows 1 to 100), and 200 in column B (rows 1 to 200), then in the next available column fill the following formula down to row 100... =IF(COUNTIF($B$1:$B$200,A1)0,"",A1) Copy those results then paste special values over the top of column A, then sort to remove blanks. Ken Johnson |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
duplicates with a twist
You're welcome. Thanks for the feedback. Ken Johnson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Checking for duplicates - think this is simple | Excel Discussion (Misc queries) | |||
| i need to find duplicates! ASAP | Excel Worksheet Functions | |||
| Duplicates | Excel Discussion (Misc queries) | |||
| Duplicates | Excel Discussion (Misc queries) | |||
| Finding Duplicates | Excel Worksheet Functions | |||
Linear Mode
