Find duplicate cells

[cpliu]

Is there a way to find all the cells with identical entry? I'm trying to
find duplicate information but I don't know what the duplicate entries are.
Find and replace does not have an option to find something like that.

TIA,


cpliu

 

[Frank Kabel]

Hi
have a look at
http://www.cpearson.com/excel/duplicat.htm#TaggingDuplicates
http://www.cpearson.com/excel/duplicat.htm#HighlightingDuplicates

 

[JE McGimpsey]

See

http://cpearson.com/excel/duplicat.htm

 

[cpliu]

Thank you all for quick pointer. I'm reading the tutorial, but can't figure
out range.

"For example, we may define Range1 on Sheet1 as A5:A14 on Range2 as C5:C14.
Blank cells are allowed anywhere within Range1 and Range2"

How do you define range so each represent multiple cells?

Thanks for the help,


cpliu

 

[Frank Kabel]

Hi
range is in this case just a dummy name for your cell references. There
are some form,ulas and you can replace the range names with your actual
range. e.g.
=COUNTIF(range,B1)
change this to
=COUNTIF(A1:A100,B1)