[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

Checking for Duplicate Values using IF Statement

Posted on 2011-05-06
3
Medium Priority
?
546 Views
Last Modified: 2012-05-11
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.  
0
Comment
Question by:jhoekman
  • 2
3 Comments
 
LVL 33

Expert Comment

by:jppinto
ID: 35710014
Please check the attached file to see if this is what you want to do.

jppinto
Duplicate.xlsx
0
 
LVL 33

Accepted Solution

by:
jppinto earned 2000 total points
ID: 35710021
Please use this, I forgot something on the previous post.

Here's the formula:

=IF(A2=A1;"Duplicate";"Unique")

jppinto
Duplicate.xlsx
0
 
LVL 12

Author Closing Comment

by:jhoekman
ID: 35710071
Worked like a charm.

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

Thanks!
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

When you see single cell contains number and text, and you have to get any date out of it seems like cracking our heads.
This article describes how to use a set of graphical playing cards to create a Draw Poker game in Excel or VB6.
This Micro Tutorial will demonstrate in Google Sheets how to use the HYPERLINK function to create live links inside your spreadsheet.
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

873 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question