Notifications
Clear all
General Excel Questions & Answers
3
Posts
2
Users
0
Reactions
73
Views
Topic starter
Hi,
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 [email protected] 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.
Posted : 28/05/2020 10:36 am
Not sure what you mean by the range needs to be fully flexible?
This seems to work, using an expanding range so you need to drag down column D
=IF(SUM(IF(IF(A2-30<=$A$2:A2,$B$2:B2,FALSE)=B2,1,0))>1,"D","")
Let me know if it is any good
Purfleet
Posted : 28/05/2020 4:37 pm
Topic starter
Purfleet, Purfect!
Posted : 29/05/2020 7:20 am
