Compare three columns for duplicates

Hi experts

I have spread sheet which has three columns, A,B,C. In each column there is an email for an user.

I want to exclude users who are EITHER/OR in column A or Column B AND in column C.

After that I need a count for the users who are left in column C.

Tried different codes and scripts but cant get it to work properly.

So if an email is present in column C and is also in A or B or both, I want them removed.

Thanks in advance.

Best regards

Daniel

Hi Special K

Thanks but when I try to paste in the code I get an error

The first C is highlighted as if there is some problems there.

Im a neewbie to excel, so I need as much help as possible, thanks.

try to upload your sample workbook, click "Go Advanced" button and find pasperclip image button to attch your file

Thanks. I just needed to change to semicolon. It works now :-)

Hi again

I found out that I also need to check for duplicates if only two columns. Column A has 66.000 rows. I thought that this would work, but I get the result 1 on each of the cells

=IF(OR(NOT(ISNA(VLOOKUP(B1;A$1:A$66000;1;0))));1;0)

Thanks

Daniel

nevermind I found a solution.

Thanks for replies.