Highlight cell duplicates in columns/rows without helper column?

Hi, just in case anything has changed…

I want to perform 'highlight duplicates' on a column (multiple) same as you can do in excel.

I know I can add a helper column to countif and mark as dupe and then add conditional formatting based on result however is there anything to avoid these additional steps that is easier, or expected as a new release? (if so, when?) I am in the EAP.

Many thanks

Find more posts tagged with

Accepted answers

All comments

I just checked for anything I could think of and I couldn't find a way to do it without a helper column. The amount of "helper" columns needed to make most of my sheets do ANYTHING interesting is typically pretty high, so I don't consider adding 1 more too onerous, personally.

=COUNTIF([YourColumn]:[YourColumn],[YourColumn]@row)

and then make it into a column formula and run conditional formatting on that column.

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.