Forum Discussion
Solved
Please Help
I'm continuing work on my golf league spread sheet. I need to create a formula that Finds the Largest 9 scores in a row. And another formula that finds the Lowest 8 scores in a row. Here is the ...
=INDEX($A4:$CP4,LARGE(IF(($A4:$CP4<>"")*($A4:$CP4<>0),COLUMN($A:$CP)),DA$3))Thanks for your reply. I've changed the formula and now it ignores blank cells and cells with 0. Now you don't need to change cells with 0 values.
I feel I need to combine the Vlookup funcion with the Large Function and then somehow have it all be looking from right to left (since the scores will be entered from left to right)