summarize purchases by client, product and date

[Deleted]

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

[#2 · Accepted 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.

[#3]

@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