how to check for returning customers in Excel 2013?
You can use this array formula:
= MAX(IF((C2:H2>0)*(B2:G2=0),$C$1:$H$1,0))
Take care to shift the range in the conditions.
how to check for returning customers in Excel 2013?
You can use this array formula:
= MAX(IF((C2:H2>0)*(B2:G2=0),$C$1:$H$1,0))
Take care to shift the range in the conditions.