Forum Discussion
Solved
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...
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))
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
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))
- 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