Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Comparing Field Contents
This is my scenario:
I have a sheet with a e-mail field and another sheet with another e-mail field (from different sources) I want to know what (if any duplications exits), does anyone have any suggestions how to do this in excel? Thanks |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Comparing Field Contents
One way: assume column A of sheets 1 & 2 contain your e-mail addresses then
In column B of Sheet1: =COUNTIF(Sheet2!A:A,A1) This will return 0 if no match found or 1 (or more) if one or matches are found. You could filter on 0 HTH "Wayne Taylor" wrote: This is my scenario: I have a sheet with a e-mail field and another sheet with another e-mail field (from different sources) I want to know what (if any duplications exits), does anyone have any suggestions how to do this in excel? Thanks |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Comparing Field Contents
Hi Toppers,
Thnaks for that, I've just had a quick play in a test spreeadsheet, I'll see how it works on the real thing.. Thanks Very Much! "Toppers" wrote: One way: assume column A of sheets 1 & 2 contain your e-mail addresses then In column B of Sheet1: =COUNTIF(Sheet2!A:A,A1) This will return 0 if no match found or 1 (or more) if one or matches are found. You could filter on 0 HTH "Wayne Taylor" wrote: This is my scenario: I have a sheet with a e-mail field and another sheet with another e-mail field (from different sources) I want to know what (if any duplications exits), does anyone have any suggestions how to do this in excel? Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Comparing cell contents with different reference cells | Excel Worksheet Functions | |||
Pivot Table - Sum Row Field Contents | Excel Discussion (Misc queries) | |||
Pivot Table - Sum Row Field Contents | Excel Discussion (Misc queries) | |||
Comparing contents of two spreadsheets and outputting results to a | Excel Worksheet Functions | |||
Comparing Workbook contents | Excel Discussion (Misc queries) |