Marking Dupes based on multiple columns

Hello everyone, long time watcher, first time caller,

I've been search for an answer for a while on the forum but I can't seem to get it to work.

I am trying to highlight duplicates entries based on more than 1 column.

I did the helper column with the duplicate check, using the countifs formula but this gives me the duplicates based only on that 1 column - in this case, I have it dupe checking the Booking column.

Here's what I'm looking for, highlight dupe only if all 3 product, amount and booking are the same.

So row 4 would not be highlighted as not all columns are the same as row 1.

Thank you in advance!

Find more posts tagged with

Formulas

Conditional Formatting

Accepted answers

All comments

Paul Newcome

What is your existing formula? If you are using a COUNTIFS, you should be able to just add more range/criteria sets to it.

jfatoliveira

=IF(COUNTIFS(Booking:Booking, Booking@row) > 1, 1) = 1

This is what I currently have - I am struggling to make the formula work with the added criterias :(

Paul Newcome

How exactly are you adding the extra range/criteria sets? Are you able to provide some of your most recent iterations as well as the outcomes?

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, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.