Hi ,
I am hoping someone will be able to help me with a formula I am trying to write. I am wanting to take the latest date that an Email Address has bounced I am writing the formula using a count indicator to determine how many times the email address is present and then am using this formula =IF((VLOOKUP(A2,A:B,2,FALSE)=B2),B2,"OLD") but I am only seeing this work when I do not have an Email Address that has bounced >1 as it seems to then invert the query and tells me that the most recent date is actually the OLD or FALSE date rather then passing back the Lasted Bounce in filed B2.
Attached is a Sample worksheet.
I would like to know if I should be editing my formula in a different way or should be using an entirely different formula.
Cheers,
Nathan
Bookmarks