I found one way for Excel to show me duplicates, and that was by using
conditional formatting with a formula like this:
IF (COUNTIF(RANGENAME, A1)>1, TRUE, FALSE)
This does work but treats each column in the range independently from the
column next to it. I want it to work like this:
A B
Mary Apple
Sue Banana
Joe Pineapple
Mary Kiwi
Mary Apple
It should only mark the 1st and the last row as being duplicates.
Thanks for any help.
conditional formatting with a formula like this:
IF (COUNTIF(RANGENAME, A1)>1, TRUE, FALSE)
This does work but treats each column in the range independently from the
column next to it. I want it to work like this:
A B
Mary Apple
Sue Banana
Joe Pineapple
Mary Kiwi
Mary Apple
It should only mark the 1st and the last row as being duplicates.
Thanks for any help.