Yogi Anand, D.Eng, P.E. Google Spreadsheet Post #805 Oct 12, 2012 www.energyefficientbuild.com.
user RSEcho24 said: (http://productforums.google.com/forum/?zx=3rrg4qfnsz5v#!category-topic/docs/spreadsheets/eT_1EaoF_A8)
user RSEcho24 said: (http://productforums.google.com/forum/?zx=3rrg4qfnsz5v#!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.
No comments:
Post a Comment