Forum Discussion
2nd last purchase date
Hi i hope to check either by pivot or formula how to get the 2nd last purcase date of a customers.
I get the 1st date of purchase from min, max for last purchase date. But stuck on the above issue. Thks & pls help
I get the 1st date of purchase from min, max for last purchase date. But stuck on the above issue. Thks & pls help
4 Replies
You may use =LARGE(dates, 2). Just in case, =LARGE(dates,1) is equivalent of =MAX(dates).
If you have any conditions it'll be bit more complex formula, but the basis is the same.
- Ok thks Sergei 😉
It would be helpful if you could provide a small sample workbook (without sensitive data).
- Ok thks, Hans 🙂
