Forum Discussion

spalmer's avatar
spalmer
Brass Contributor
Dec 07, 2023

Formula Help

Hi everyone,  in need of some formula help.  in the attached spreadsheet, i am trying to fill the top 3 sales people in baseball sales hopefully using a formula.  You will see in row 5 i have basebal...
Excel
Formulas and Functions
  • OliverScheurich's avatar
    OliverScheurich
    Dec 07, 2023

    spalmer 

    You are welcome. This formula works in the actual file.

     

    =INDEX($J$21:$T$21,MATCH(LARGE($J$22:$T$22,COLUMN(A1)),$J$22:$T$22,0))

     

spalmer's avatar
spalmer
Brass Contributor

attached is where the actual data is on my actual spreadsheet.  Was just trying to give a simple version of it but it seems this column function needs to be exact.  thank you for helping me Oliver.  Hopefully this new attached file will be easier to see then me explaining it.  

 

thank youOliverScheurich 

OliverScheurich's avatar
OliverScheurich
Gold Contributor
Dec 07, 2023

spalmer 

You are welcome. This formula works in the actual file.

 

=INDEX($J$21:$T$21,MATCH(LARGE($J$22:$T$22,COLUMN(A1)),$J$22:$T$22,0))

 

  • spalmer's avatar
    spalmer
    Brass Contributor
    Dec 07, 2023
    Thank you very much Sir, i figured out what was wrong. because i tried that exact formula but it was adding an extra column because i have those merged. so it was giving me J22:T23 instead of T22. geezzzz. haha.. well thank you again very much for your time Oliver