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))

     

OliverScheurich's avatar
OliverScheurich
Gold Contributor

spalmer 

=INDEX($C$4:$M$4,MATCH(LARGE($C$5:$M$5,COLUMN(A1)),$C$5:$M$5,0))

You can try this formula. Enter the formula with ctrl+shift+enter if you don't work with Office 365 or Excel for the web or Excel 2021.

 

spalmer's avatar
spalmer
Brass Contributor
Dec 07, 2023
its not working on my actual spreadsheet because the data is in different rows and columns then the spreadsheet i attached. the data on my actual spreadsheet starts on I21:T33. Where i would like the names inputted #1 is L45, #2 is M45 and #3 is N45. Thats why i was wondering what the COLUMN Function had to do with it

Resources