Averages - Golf League Scoring
On Jan 4, 6:03*pm, Larry L wrote:
There is a problem with the formula. It doesn't like ISNUMBER.
Is this an array formula that requires CTRL+SHIFT+ENTER?
"barry houdini" wrote:
Hello Larry,
Here's another option
=IF(COUNT(501:501),AVERAGE(SMALL(INDEX(501:501,LAR GE(IF(ISNUMBER
(501:501),COLUMN(501:501)),MIN(COUNT(501:501),20)) ):IV501,ROW(INDIRECT
("1:"&MIN(COUNT(501:501),10))))),"")- Hide quoted text -
- Show quoted text -
Yes, Larry, it's also an array formula that needs CSE.
Some spaces got inserted in the formula when posting. There are no
spaces in the formula so any spaces after ISNUMBER and after ROW
(INDIRECT need to be removed....formula should then work. Should work
better below perhaps.....
=IF(COUNT(501:501),AVERAGE(SMALL(INDEX(501:501,LAR GE(IF(ISNUMBER
(501:501),COLUMN(501:501)),MIN(COUNT(501:501),20)) ):IV501,ROW(INDIRECT
("1:"&MIN(COUNT(501:501),10))))),"")
|