• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 7348
  • Last Modified:

Google Docs - Highlight duplicate values in cell range

In Google Docs "If a duplicate value is found, highlight it".  How do I do this?
0
rtod2
Asked:
rtod2
1 Solution
 
SiddharthRoutCommented:
Ted, There is no direct way of doing it.

To determine duplicates, add a column say B and place this formula in B1. I am assuming that the data is in Col A

 =countif(A$1:A1;A2)>0

Copy the formula for all B cells that are adjacent to A cells containing data.

A TRUE value in the B column tells you that the value in the A column is a duplicate.

Sid
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now