Jul 30 2019 05:30 AM
Jul 30 2019 05:30 AM
Hi,
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,
Salvador
Jul 30 2019 08:39 AM
Solution@Deleted
Hi,
You need this array formula:
=IFERROR(INDEX($C$2:$C$12,INDEX(MATCH($E2&SMALL(IF($E2=$A$2:$A$12,$B$2:$B$12,""),COLUMN(A1)),$A$2:$A$12&$B$2:$B$12,0),)),"")
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.
Jul 30 2019 08:51 AM
@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,
Salvador
Jul 30 2019 08:39 AM
Solution@Deleted
Hi,
You need this array formula:
=IFERROR(INDEX($C$2:$C$12,INDEX(MATCH($E2&SMALL(IF($E2=$A$2:$A$12,$B$2:$B$12,""),COLUMN(A1)),$A$2:$A$12&$B$2:$B$12,0),)),"")
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.