With almost universal availability of Internet and the availability of reliable on-line productivity tools, such as Google Docs, individuals as well as companies are switching over to Cloud Computing. In this blog I will post items of interest to my colleagues/patrons/clients.
Monday, September 3, 2012
yogi_Workaround For Highlighting Duplicates In Nearly The Same Column
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.