Forum Discussion

mdmiles1485's avatar
mdmiles1485
Copper Contributor
May 16, 2023
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 ...
excel
  • OliverScheurich's avatar
    OliverScheurich
    May 16, 2023

    mdmiles1485 

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

     

mdmiles1485's avatar
mdmiles1485
Copper Contributor
May 16, 2023
Okay before I attempt. Do you feel I should try and achieve blanks for cells that currently hold a value of 0? Also thanks so much for even attempting to help me on this. I've been stumped.