D
Dave Peterson
I don't see where you tried the last suggestion:
=IF(COUNTIF(D1250;">0")<20;"not enough numbers";
INDEX(D1250;LARGE(IF(D1250>0;ROW(D1250));21-ROW(INDIRECT("1:20")))))
=IF(COUNTIF(D1250;">0")<20;"not enough numbers";
INDEX(D1250;LARGE(IF(D1250>0;ROW(D1250));21-ROW(INDIRECT("1:20")))))
2nd Formula
=INDEX(D1250;LARGE(IF(D1250>0;ROW(D1250));21-ROW(INDIRECT("1:20"))))
RESULT
52
0
0
0
96
96
0
#NUM!
#NUM!
#NUM!
#NUM!
#NUM!
#NUM!
#NUM!
#NUM!
#NUM!
#NUM!
#NUM!
#NUM!
#NUM!