Excel 2000 Formula Haaalp! :p

grrr..

I'm trying to HIGHLIGHT DUPLICATE VALUES in a column and need a formula to do it!

I've tried these conditional formatting formulas

=COUNTIF($A$2:$A$11,A2)>1

-and-

=IF(COUNTIF(Range1, A5)>1,TRUE,FALSE)

and those do NOT work. ;-/

Could someone pleeease provide me with a working formula to highlight duplicate entries?

I have almost 4000 rows of data in which to find possible duplicates, all of which are in the same column.

Thank you!

[DVNT1]

This example just worked for me... http://www.exceltip.com/st/Find_dupl...Excel/605.html ...then add conditional formating based on the value = "Unique"

Just ignore the combine columns part.

Note: the first time an entry is found it is not labeled as Duplicate, but the 2nd time it is found, that 2nd entry is labeled "Duplicate"

cant' get to work, i must be unclear on your 'based on the value = "Unique", or something...

Could you please clarify or post the exact formula used and how you applied?

thanks so much!

*edit: just saw your edit.. let me try again..

**please post the EXACT formula and how applied... ? I'm not good at this and it's urgent ..

thanks..!

. i hate being confused lol ;p

i wonder if it's some 'feature' or 'option' ticked [or not] in Excel giving me grief? Or is it just me again [most likely eh]

[no1_vern]

Did you remove the space before inserting the formula? Also type in your cell instead of the formula cells.

blasted caching is not showing my edits.


I can't get this to work.. could you please post your exact formula and how you applied it?

I'm not very good at excel formulas... Thanks alot!!

Vern, sorry, what space? what formula cells??

I have a LONG column of numbers [values] and I want to find the duplicate entries in that column...

going to kickbox something...

[DVNT1]

My data was in column C1 through C7


Paste the following in D1:

=IF(COUNTIF($C$1:C1,C1)>1,"Duplicate","Unique")

Then copy D1 down through D7

w00T!!! *kisses DVNT1* haha

THANKS! that worked on my sample!!

I can stop losing money now. Thanks, DVNT1!!!

[DVNT1]

Always a pleasure to help you SocalGal.