Hi Kelly

something along the lines of
=IF(AND(B3=B4,C3=C4),"delete","don't delete")

Cheers
JulieD

"Kelly Lacey" <Kelly wrote in message
...
Using Excel 2000, I need to identify rows that have matching cells. For
example, B3=B4 and C3=C4. I have used the and/if function in the past and
been able to add something to show me what was duplicated but it has been
so
long I can't remember how. I have a delete macro but I need to see what
is
duplicated instead of just getting rid of the duplicates.