Hello all
I need a league table of sorts
Please see attached
Assy Tab – I need Colum B to display the top 5 part numbers based on the sales value in column AI on the MFG tab highlighted in red..
Expected data is entered on ASSY tab
Thanks for looking
I assume you have 1st and 2nd swapped by accident?
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
yes, that correct, my bad
B2:
=IFERROR(INDEX(MFG!R:R,MATCH(C2,MFG!S:S,0)),"")
C2:
=INDEX(MFG!S:S,AGGREGATE(15,6,ROW(MFG!$AI$2:$AI$36)/(MFG!$AI$2:$AI$36=D2),COUNTIF(D$2:D2,D2)))&""
D2:
=IFERROR(1/(1/LARGE(MFG!$AI$2:$AI$36,ROWS(D$2:D2))),"")
The formula at C2 will return the correct answer, even if there are ties for the amounts.
thanks Glenn
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks