Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Finding Repeated Items in Excel 2003
I'm working on a Spreadsheet where Column A and Column B are filled with
E-mail addresses. I created the following formula to find out what E-mail address in Column A repeats in Column B and vice versa, but it does not work: =ISNA(MATCH(B2,$A$2:$A4661,FALSE)) All i get is True for everything including the blank cells. I try to do the reverse and see what e-mail address in each column does not repeat, but it did not work. Any Help? Thanks, |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Finding Repeated Items in Excel 2003
Ok, so now i tried this formula:
=SUMPRODUCT(($A$2:$A$662=A2)--($B$2:$B$662=B2)) but when it encounters a blank cell in column b it counts the items as 7. What am I doing wrong. "Marilyn" wrote: I'm working on a Spreadsheet where Column A and Column B are filled with E-mail addresses. I created the following formula to find out what E-mail address in Column A repeats in Column B and vice versa, but it does not work: =ISNA(MATCH(B2,$A$2:$A4661,FALSE)) All i get is True for everything including the blank cells. I try to do the reverse and see what e-mail address in each column does not repeat, but it did not work. Any Help? Thanks, |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Automatic totalling of spend on repeated items | Excel Discussion (Misc queries) | |||
Finding repeated data in adjacent cells | Excel Discussion (Misc queries) | |||
finding repeated numbers | Excel Worksheet Functions | |||
Excel: Find repeated items and be able to delete quickly, option. | Excel Worksheet Functions | |||
Finding repeated data in a excel spreadsheet | Excel Discussion (Misc queries) |