View Single Post
  #2   Report Post  
Spencer101 Spencer101 is offline
Senior Member
 
Posts: 663
Default

Quote:
Originally Posted by karl e View Post
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?