COUNTIFS with OR

I am trying to create a function using COUNTIFS with an OR function and am struggling to find an answer to my issue. I've tried using the AI formula generator and have searched through here for answers but none have been successful.

I need a formula that will flag rows that have the same value in column 1 and column 2 OR has the same value in column 3. I am trying to flag rows with the same for first and last name OR the same email.

Right now I have this formula:

=IF(OR(COUNTIF(Email:Email, Email@row) > 1, 1, 0), IF(COUNTIFS([First Name]:[First Name], [First Name]@row, [Last Name]:[Last Name], [Last Name]@row) > 1, 1, 0))

However, this formula is flagging rows that have an email but no first name and last name.

Find more posts tagged with

Accepted answers

All comments

Shimanta Roy

I believe what you want to achieve here doesn't require a OR function. Could you check the following one?

=IF(COUNTIF(Email:Email, Email@row) > 1, 1, IF(COUNTIFS([First Name]:[First Name], [First Name]@row, [Last Name]:[Last Name], [Last Name]@row) > 1, 1, 0))

E. Truitt

Unfortunately, I'd already tried this one. It causes rows with only an email and rows only with first and last name to be flagged. Not duplicates

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.