duplicates

[rech340]

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.

 

[Dave Patton]

On 2002-08-28 19:51, rech340 wrote:
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.

In an adjacent column, concatenate the two columns with a formula like

=B2&"|"&C2

Then determine if info in this column is duplicated.


The "|" is included in case you
have information like 1 11 and 11 1

With simple concatenation (=B3&C3) the result is 111 but the information is different,

With suggested formula

1|11
11|1