Friday, October 12, 2012

yogi_Workaround For Highlighting Duplicates In A Column -- A Formula based Approach

Yogi Anand, D.Eng, P.E.      Google Spreadsheet   Post  #805  Oct 12, 2012

user RSEcho24 said: (!category-topic/docs/spreadsheets/eT_1EaoF_A8)

Conditional formatting setup for locating duplicate entries in a single column. 
I have found a couple of scripts that work to locate duplicate entries across an entire G Spreadsheet, but I am trying to figure out how to locate duplicate entries in a single column.  Does anyone have any advice how I could do this?

Greatly appreciate anyone help!
Hi there yogia,

Due to company restrictions, it wasn't letting me share it with you.  I have sent it to you as an attachment though, were you able to open it?

Thanks again.
In Google spreadsheet as of now (Oct-2012), Conditional Formatting can not be applied based on a formula
so, I propose the following workaround

If you have to highlight the duplicated in-situ (in place) then you need to explore doing that using Google Apps Script.