Link to home
Start Free TrialLog in
Avatar of jhoekman
jhoekmanFlag for United States of America

asked on

Checking for Duplicate Values using IF Statement

Hey guys, I have a column of emails and I want to create another column that looks to see if the email in one row is the same as the row before it, and if it is, pass the word 'Duplicate' and if it isn't, pass the word Unique.  

I am sure it's simple, but I have tried what I know of IF statements and it's not working.  
Avatar of jppinto
jppinto
Flag of Portugal image

Please check the attached file to see if this is what you want to do.

jppinto
Duplicate.xlsx
ASKER CERTIFIED SOLUTION
Avatar of jppinto
jppinto
Flag of Portugal image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of jhoekman

ASKER

Worked like a charm.

Funny thing is, that is exactly what I was putting in.  Must have been some sort of PEBKAC error.  :)

Thanks!