Formula to look for duplicates using multiple criteria
Hello,
I currently have this formula which is looking for duplicates in APPID:
=IF(COUNTIF(APPID:APPID, APPID@row) > 1, "FLAG")
I would like to add another formula to this which will look first at the APPID to see if they are the same, and then look in the N column to see if the name is the same.
If the name is the same, then it should return "FLAG", if the name is not the same, it should not flag it all.
APPID = 1234, and N = ABC
APPID = 1234, and N = DEF
In this case, the formula should not flag this as a duplicate because the value of N is not the same. If the value of N had been ABC in the second occurrence, then FLAG should be returned.
I was wondering if someone could please help me figure this one out, thanks!
Answers

Change from a COUNTIF to a COUNTIFS (with the "S" on the end) to use multiple range/criteria sets and then add your new range/criteria set to the COUNTIFS.

Thank you, what criteria would I use to ensure that column N is not the same on the two rows. For example, column N cannot Car and Car, and have the same APP ID. I want the formula to return FLAG when the APPID is the same AND the N is not both Car and Car.

It would be the same logic as you already have. You are counting rows where the APPID is the same as "@row", you would do the same with N "@row".
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 62.1K Get Help
 349 Global Discussions
 198 Industry Talk
 427 Announcements
 4.4K Ideas & Feature Requests
 133 Brandfolder
 127 Just for fun
 127 Community Job Board
 455 Show & Tell
 28 Member Spotlight
 1 SmartStories
 283 Events
 36 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!