check an column if anything matches completely

[itzmemike]

Hello,
I was wondering let say I'm entering like tons of digits in an cell column. Only in that column have all that digits, I was wondering if there anyway in excel to figure out if any of those numbers completely matched, meaning there an duplicate. Let say line 2 have 12345 and line 12 have 12345, thats completely matching and I want to find those with the least time consuming.

[galvinpaddy]

Conditional formatting can instantly highlight duplicates.
I also have excel 2010, so first highlight your data range, then along the top, click HOME, towards the middle of the page, click CONDITIONAL FORMATTING, click HIGHLIGHT CELLS RULES, click DUPLICATE VALUES, Click OK. this will highlight any duplicates in red.
Is that what you are after?

[itzmemike]

Ah Yes, thank you so much
Lastly do you know how to take off that highlighted text & cell after founding all the duplicates.
Also when i went inside the duplicate value i see that the default value is duplicate, but i see another value called "unique" do you know what that is, perhaps in the future i might find it useful.

[galvinpaddy]

At a guess, i imagine it would only highlight unique values cant promise though as i have never used it!
If you want to then remove the conditional formatting, simply highlight your range again, click conditional formatting, clear rules, clear rules from selected cells.
Happy to help, if your quety is solved could you mark it as solved and click the star under my username details? much appreciated!
galvinpaddy