Return New Value if 4 column matches

Copper Contributor

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? Excel.png

2 Replies

@Shahriar20 

=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.

countifs.JPG 

Thank you