Check a box for duplicate rows, if also duplicate responses in another column

Hi!

Hoping I can get some tips on a formula I am struggling with. I am trying to mark a check box based on if I have duplicates, based on two columns.

I am trying to identify duplicates between two rows by doing the following; (1) check entire sheet in one column for the same employee ID number (EID), and then for the rows with a duplicate EID check to see if the rows with the same EID also contain the same ID Color (ID Color).

Any suggestions would be helpful.

Find more posts tagged with

Accepted answers

Paul Newcome

You would use an IF/COUNTIFS combo like so:

=IF(COUNTIFS(EID:EID, @cell = EID@row, [ID Color]:[ID Color], @cell = [ID Color]@row)> 1, 1)

All comments

Trang Turtletraxx

@Paul Newcome you're AMAZING! That's exactly it. I was missing the @cell reference. Thank you!

Paul Newcome

@Trang Turtletraxx Happy to help. 👍️

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.