I have multiple raw for each purchase of every client (data are sorted by client number then by date of purchase)
For instance, client number one purchased 5 times and 3 different products
I would like to know which product he bought firstly, secondly and so on.
The output I want is in green just below and my input is the table on the left below
Thanks in advance,
View best response
You need this array formula:
But you have to press Ctrl+Shift+Enter not only Enter each time you enter this formula.
Please check it out in the attached file.
@Haytham Amairah thank you so much.
The world needs geniuses like you. If you come in France, just let me know, I will pay you a beer.
have a good day,