Hi,
This is the first time I've posted here so apologies if any of this is incorrect.
I have a list of products ordered by week with their volume.
I would like to select the top ten products by week. I have found and used the formula which gets the top ten, but I am struggling to do it by week.
Formula I used to get top 10: =INDEX(C$2:$C$28,MATCH(1,INDEX(($D$2:$D$28=LARGE($D$2:$D$28,ROWS(I$2:I4)))*(COUNTIF(I$2:I4,$C$2:$C$28)=0),),0))
One of the ways I have tried to do it by category: =INDEX(C$2:$C$28,MATCH(1,($I$2=$A$2:$A$28)*(INDEX(($D$2:$D$28=LARGE($D$2:$D$28,ROWS(I$2:I2)))*(COUNTIF(I$2:I2,$C$2:$C$28)=0),)),0))
If this is not possible, I will have to do this in two steps by first creating a table of products by week, then selecting the largest.
Any help is greatly appreciated![Smile :) :)](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f642.png)
Thanks,
Jo
This is the first time I've posted here so apologies if any of this is incorrect.
I have a list of products ordered by week with their volume.
I would like to select the top ten products by week. I have found and used the formula which gets the top ten, but I am struggling to do it by week.
Formula I used to get top 10: =INDEX(C$2:$C$28,MATCH(1,INDEX(($D$2:$D$28=LARGE($D$2:$D$28,ROWS(I$2:I4)))*(COUNTIF(I$2:I4,$C$2:$C$28)=0),),0))
One of the ways I have tried to do it by category: =INDEX(C$2:$C$28,MATCH(1,($I$2=$A$2:$A$28)*(INDEX(($D$2:$D$28=LARGE($D$2:$D$28,ROWS(I$2:I2)))*(COUNTIF(I$2:I2,$C$2:$C$28)=0),)),0))
If this is not possible, I will have to do this in two steps by first creating a table of products by week, then selecting the largest.
Any help is greatly appreciated
![Smile :) :)](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f642.png)
Thanks,
Jo
Attachments
Last edited by a moderator: