Jul 15 2022 03:48 AM
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?
Jul 15 2022 04:00 AM
=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.