Calculating a Duplicate if meeting 2 separate criteria

Hi, I'm currently calculating if something is a duplicate by using the following formula:

=IF(AND([PASS NUMBER]@row <> "", COUNTIFS([PASS NUMBER]:[PASS NUMBER], [PASS NUMBER]@row) > 1), "Duplicate", "Not a Duplicate")

However, I now intend to expand the use of this sheet, so would like to include another column to specify the site. How can I incorporate the site column to determine if the row is an actual duplicate?

e.g. if two '14' pass numbers were issued. One for the Hay site and one for the Cardiff site. I wouldn't want this to flag as a duplicate. Only if '14' was used twice at the Hay site.

Thanks!

Find more posts tagged with

Formulas

Accepted answers

JamesB

@Jack Parry

If I understand your request, this should work for you.

=IF(COUNTIFS([Pass Number]:[Pass Number],[Pass Number]@row,Site:Site,Site@row)>1,"Duplicate","Not Duplicate")

All comments

JamesB

@Jack Parry

If I understand your request, this should work for you.

=IF(COUNTIFS([Pass Number]:[Pass Number],[Pass Number]@row,Site:Site,Site@row)>1,"Duplicate","Not Duplicate")

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.