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