• 461K Members
• 12.1K Online
• 558K Conversations
SOLVED

Deleted
Not applicable

# summarize purchases by client, product and date

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

2 Replies
Solution

# Re: summarize purchases by client, product and date

@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.

# Re: summarize purchases by client, product and date

@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,

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies