Hello,
I have inherited a system where tools are tracked in a Gagetrak database, and also tracked in a company database.
I am trying to sort and mark from the attached example, all duplicate cells, and also somehow mark the cells with more than one entry since the data I get shows all locations, not just current.
I have used bold text to show the file copied from. I am not able to get what I need and I appreciate any help!
Thank you,
Gary
Last edited by cp49321; 02-09-2012 at 01:20 PM.
Maybe this will help....put this formula in I2 and copy down...
=IF(COUNTIF(A:A,A2)>1, "Duplicated", "")
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
“None of us is as good as all of us” - Ray Kroc
“Actually, I *am* a rocket scientist.” - JB (little ones count!)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks