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