Forum Discussion
Return New Value if 4 column matches
I'm trying to find repeat customers for our company. I'm trying to return value on the "repeat" column if 4 different columns match (Customer_Name, Street_Address, Latitude, Longitude). What's the formula?
2 Replies
=IF(COUNTIFS($A$2:$A$4,A2,$B$2:$B$4,B2,$C$2:$C$4,C2,$D$2:$D$4,D2)>1,"repeat","")Maybe with the COUNTIFS function.
- Thank you
