Google Docs - Highlight duplicate values in cell range

In Google Docs "If a duplicate value is found, highlight it".  How do I do this?
rtod2Asked:
Who is Participating?
 
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.