Hi everyone,
On the attached sample file, I used this array formula to lookup fo the "First purchase date" - {=MIN(IF((Sheet2!A:A=Sheet1!A2),Sheet2!B:B))}
However, for the "Second purchase" and "Third purchase", i'm stuck and can't think on how to return the dates.
Can anyone help me on this?
Thank you in advance!
Bookmarks