Find duplicate cells

  • Thread starter Thread starter cpliu
  • Start date Start date
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
 
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
 
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)
 
Back
Top