May 28, 2020
I have leads being Zapped into a sheet, 24/7.
If the newest lead has been entered before, with the same email address, within the last 30 days, set a flag.
I have attached a sample of what I'm trying to achieve:
- latest lead is entered today
- If firstname.lastname@example.org appears in the column within the last 30 days, then enter "D" in the last column
The range needs to be completely flexible, so I tried variations of COUNTIFS($A:$A, A9, $B:$B,B9) - but to no avail.
Any help gratefully received.
December 20, 2019