LinkBack URL
About LinkBacks
I have a list of items in B3-B15 and in C3-C15 the number of each item
In E3 and E3 i would lover the items and number of items in highest order, please
Sheet attached.
I have a list of items in B3-B15 and in C3-C15 the number of each item
In E3 and E3 i would lover the items and number of items in highest order, please
Sheet attached.
Last edited by TrainerJ; 11-16-2017 at 07:47 AM.
Why not simply sort range B3:C15 ?
let Source = #table({"Question","Thread", "User"},{{"Answered","Mark Solved", "Add Reputation"}}) in Source
If I give you Power Query (Get & Transform Data) code, and you don't know what to do with it, then CLICK HERE
Walking the tightrope between genius and eejit...
This range will change often so want the E3 and E4 to be consistent if that makes sense.
reattach the file with expected resultOriginally Posted by TrainerJ
Samba
Say thanks to those who have helped you by clicking Add Reputation star.
I'm not sure what you're asking. Do you want the list automatically sorted in columns E and F? (That is, did you mean cells E3 and F3?)
Clicking the Add Reputation star below helpful posts is a great way to show your appreciation.
Please mark your threads as SOLVED upon conclusion (Thread Tools above Post # 1). - Lee
Iv changed the document to show what I would like
thanks again
A very simple way would be to use a pivot table, which you can then simply refresh when your source data changes.
Paste this in E3 and copy down:Paste this in F3 and copy down:
=IFERROR(INDEX(B$3:B$15,MATCH(LARGE(INDEX($C$3:$C$15+1/ROW($C$3:$C$15),),ROWS(E$3:E3)),INDEX($C$3:$C$15+1/ROW($C$3:$C$15),),0)),"")=IFERROR(LARGE(INDEX($C$3:$C$15,),ROWS(F$3:F3)),"")
Last edited by leelnich; 11-17-2017 at 07:15 AM.
Perfect thank you
You're most welcome, thank you for the rep!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks