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?

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
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2

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
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2