Duplicate with Criteria

[karl e]

Hello -

Would anyone be able to help with a Duplicate with Criteria formula.

Thank you!

Formula needed for:

If "Number" column is a duplicate, and "Name" = B, then "X", if not
blank.


Name Number A B C
A 1
B 2
B 3 X
C 3
B 3

 

[Spencer101]

Hello -

Would anyone be able to help with a Duplicate with Criteria formula.

Thank you!

Formula needed for:

If "Number" column is a duplicate, and "Name" = B, then "X", if not
blank.


Name Number A B C
A 1
B 2
B 3 X
C 3
B 3 X

Hi,
Simple to do with a "helper column". Would that be an option for you

 

[Claus Busch]

Hi Karl,

Am Tue, 19 Jun 2012 01:06:44 +0000 schrieb karl e:

If "Number" column is a duplicate, and "Name" = B, then "X", if not,
blank.

Name Number A B C
A 1
B 2
B 3 X
C 3
B 3 X

in C2 try:
=IF(AND(COUNTIF(B:B,B2)>1,A2="B"),"X","")


Regards
Claus Busch

 

[Claus Busch]

Hi Karl,

Am Tue, 19 Jun 2012 09:50:53 +0200 schrieb Claus Busch:

in C2 try:
=IF(AND(COUNTIF(B:B,B2)>1,A2="B"),"X","")

if you want to do it for all names, then in C2:
=IF(AND(COUNTIF($B:$B,$B2)>1,$A2=C$1),"X","")
and drag down and to right.


Regards
Claus Busch