Monday, September 3, 2012

yogi_Workaround For Highlighting Duplicates In Nearly The Same Column

Yogi Anand, D.Eng, P.E.       Google Spreadsheet    Post  #729   Sep 03, 2012     www.energyefficientbuild.com.

user Kylecore said: (http://productforums.google.com/forum/?zx=nclx24r3fxl3#!category-topic/docs/spreadsheets/OgevrVSm02o)
Yogia help!
I came across this tonight :
http://spreadsheets.google.com/pub?key=tfa10vy3An0f9ES56cnyYWQ&single=true&gid=5&output=html 

It looks exactly like something i need for a task I've been working on except I'm slightly confused on how to implement it and i need a few more specifics.

I have a few things I'd need slighty different however.
One is that i have columns "A"-"I" already in use.
I still only need to check for duplicates in column "A" only but would prefer for it to simply colour the box or text within column "A" instead of putting a colour or word in another column like "J".
I need to compare up to 1000 rows at some times and I do NOT want anything deleted.
I would like to be shown where the duplicates are for me to remove later.
The data being compared in column A is solely numbers with no text, not sure if it makes a difference.
Is there any way this can be done
I've also included an example image to show you what i am requsting

Currently i have a filter set up to remove certain things from my list but no idea on how to accomplish the above.
Any response at all would be greatly appreciated, and thank you very much for reading.
------------------------------------------------------------------------------
following is a solution to the problem


No comments:

Post a Comment