Highlight cell duplicates in columns/rows without helper column?

melimob

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

Jgorsich

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.