Identify duplicates with multiple criteria

Hi,

I need to identify rows that have the same Invoice No (text column), the same Supplier Name (text column), but different Funding Date (date column) and flag the row.

This is the formula I attempted that did not work:

=IF(COUNTIFS([Invoice No]:[Invoice No], [Invoice No]@row, [Supplier Name]:[Supplier Name], [Supplier Name]@row, [Funding Date]:[Funding Date], <>[Funding Date]@row) > 1, 1)

Any help would be much appreciated. Thank you!

Find more posts tagged with

Accepted answers

Paul Newcome

@alexis.ray89371 I believe we may have this answered here:

https://community.smartsheet.com/discussion/98820/flag-a-row-when-compared-to-other-rows

All comments

Paul Newcome

@alexis.ray89371 I believe we may have this answered here:

https://community.smartsheet.com/discussion/98820/flag-a-row-when-compared-to-other-rows

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.