COUNTIFS and Duplicate Values

Hello! I need to figure out a way count the number of records in my issue log, EXCEPT if the records have the same parent number, they can only be counted once.

Is there an easy way to do this? Is there a way to use the DISTINCT formula in the "Parent" column, but also count the blank rows, as long as the Record column isn't blank?

I am open to any suggestion! Thank you in advance!

Find more posts tagged with

Sheets

Formulas

functionality

Accepted answers

kelceyg

I figured out my own solution:

Added a helper checkbox row and used a formula to identify duplicates in the "Parent" column: =IF(COUNTIFS(Parent:Parent, Parent@row, Parent:Parent, NOT(ISBLANK(@cell))) > 1, 1)

I then set up a workflow with the logic "If "Duplicate" column is checked, copy row." I copied the rows to a helper sheet.

Since my helper sheet only included the rows with duplicates, I was able to utilize the DISTINCT function.

All comments

kelceyg

I figured out my own solution:

Added a helper checkbox row and used a formula to identify duplicates in the "Parent" column: =IF(COUNTIFS(Parent:Parent, Parent@row, Parent:Parent, NOT(ISBLANK(@cell))) > 1, 1)

I then set up a workflow with the logic "If "Duplicate" column is checked, copy row." I copied the rows to a helper sheet.

Since my helper sheet only included the rows with duplicates, I was able to utilize the DISTINCT function.

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.