Find duplicate cells

C

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
 
C

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
 
F

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)
 
Top