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.
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.
=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.
- Ok I did change them and found that it still did not find a value. I'm wondering if its because the target cells we are trying to find for the last 10. Those values are achieved with a formula. In my case I'm trying to find the values of the difference of their scores to par. in this case par is 36. so you'll see the values I'm trying to get the last 10 for aren't their actual scores. Its the difference from there actual scores to par. So as you'll see its acheived with a small formula. could that formula be hindering the formula you've given me? as opposed to a raw number in that cell?
- Nope your new formula worked !!!!!!!!!!!!!Oh youve made my day. holy crap. Thank you so much. If you were here I'd buy you a beer. Thanks again!!!!!!