I'm trying to label rows as "Duplicate" in Column Q if i have a duplicate phone number in Column G across multiple tabs. I'm struggling with the formula.
So far, I have:
=IF(COUNTIFS($G$8:$G$2020, G8, 'FW 4'!$G$8:$G$2020, G8),>1,"Duplicated","")
But it's not recognizing the second Criteria Range from another tab.
What am I doing wrong?
Thanks y'all!
So far, I have:
=IF(COUNTIFS($G$8:$G$2020, G8, 'FW 4'!$G$8:$G$2020, G8),>1,"Duplicated","")
But it's not recognizing the second Criteria Range from another tab.
What am I doing wrong?
Thanks y'all!