Forum Discussion
spalmer
Dec 07, 2023Brass Contributor
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...
- Dec 07, 2023
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
Dec 07, 2023Gold Contributor
=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
Dec 07, 2023Brass Contributor
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