Forum Discussion
Solved
Filling an item name from rated and ranked cells
I'm trying to get Excel to fill a column with item names that have been ranked according to a rating. Table one: column A - there are five items in their original order (A,B,C,D,E), column B - th...
- I think this is what you're looking to do:
365 solution: =SORTBY(A18:A22,D18:D22,-1)
Non-365 solution (array enter): =INDEX($A$18:$A$22,SMALL(IF($D$18:$D$22=I18,ROW($A$18:$A$22)),COUNTIF($I$18:I18,I18))-17,1)
I think this is what you're looking to do:
365 solution: =SORTBY(A18:A22,D18:D22,-1)
Non-365 solution (array enter): =INDEX($A$18:$A$22,SMALL(IF($D$18:$D$22=I18,ROW($A$18:$A$22)),COUNTIF($I$18:I18,I18))-17,1)
365 solution: =SORTBY(A18:A22,D18:D22,-1)
Non-365 solution (array enter): =INDEX($A$18:$A$22,SMALL(IF($D$18:$D$22=I18,ROW($A$18:$A$22)),COUNTIF($I$18:I18,I18))-17,1)
Thank you so much Patrick2788 both seem to have worked!!! Now I will go and read up on those functions to figure out how they work 🙂
