Forum Discussion

johngrade's avatar
johngrade
Copper Contributor
Jul 11, 2023
Solved

Index matching numbers across a row with dupes

Hey folks! I'm pretty green to excel functions and could use some help:    I inherited a report (that has been scrubbed) that is using a simple index-matching formula to pull the top 4 items ...
excel
Formulas and Functions
  • mtarler's avatar
    mtarler
    Jul 11, 2023

    Maybe something like:
    =TAKE(SORTBY(FILTER($B$1:$I$1,$B2:$I2>0,""),FILTER($B2:$I2,$B2:$I2>0,0),-1),,4)

mtarler's avatar
mtarler
Silver Contributor
Jul 11, 2023

Maybe something like:
=TAKE(SORTBY(FILTER($B$1:$I$1,$B2:$I2>0,""),FILTER($B2:$I2,$B2:$I2>0,0),-1),,4)

  • johngrade's avatar
    johngrade
    Copper Contributor
    Jul 12, 2023
    I got this formula to work well for me! Thank you so much!!

Resources