Please refer to the help file attached.
In a nutshell, there are two problems:
-1st issue: find the largest 5 values per each available date.
-2nd issue: find the number of unique Team Members.
sounds silly, but I'm having a hard time on this. maybe burned out ^^.
ENTRY ERROR IN HELP FILE:
Nathan should be TEAM A, Not blank!
based on your file:
Formula:
G3:
=IFERROR(AGGREGATE(14;6;sales_data[Sales]/(sales_data[Date]=G$2);ROWS(G$3:G3));"")
applied to matrix G3:I7
M3:
=SUMPRODUCT((sales_data[A]=RIGHT($L2))/COUNTIFS(sales_data[A];sales_data[A]&"";sales_data[Seller];sales_data[Seller]&""))
copied to M4
Thank you!
Last question: Would there be anyway to also, in a separate column, indicate the seller responsible for such sales according to the 5 largest values per date?
ie. 3/1/2019:
1st largest: 10 - Ricky
2nd largest: 8 - Mark
and so on...
Hi
I'm using ";" as delimiter in the formula
In G3:I9 numbers from AGGREGATE
In J3 to be copied across
=INDEX($C$3:$C$22;AGGREGATE(15;6;ROW($3:$22)-2/(($A$3:$A$22=G$2)*($B$3:$B$22=G3));COUNTIF(G$3:G3;G3)))
or setting "," as delimiters
=INDEX($C$3:$C$22,AGGREGATE(15,6,ROW($3:$22)-2/(($A$3:$A$22=G$2)*($B$3:$B$22=G3)),COUNTIF(G$3:G3,G3)))
Regards
Last edited by canapone; 04-01-2019 at 05:40 AM.
-----------------------------------------------------
At Excelforum, you can say "Thank you!" by clicking the star icon ("Add Reputation") below the post.
Please, mark your thread [SOLVED] if you received your answer.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
ierosadopr 
Register To Reply
Bookmarks