Forum Discussion
Formula Help
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))
=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.
=LARGE(array, k)
Within the LARGE function k represents the k-th largest value.
In cell B25 for k the expression COLUMN(A1) evaluates to 1.
In cell C25 for k the expression COLUMN(B1) evaluates to 2.
In cell D25 for k the expression COLUMN(C1) evaluates to 3.
COLUMN(A1) allows to select the first, second, third-largest value when the formula is filled across the row.
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))