Blank cells

D

Dave Peterson

I don't see where you tried the last suggestion:

=IF(COUNTIF(D1:D250;">0")<20;"not enough numbers";
INDEX(D1:D250;LARGE(IF(D1:D250>0;ROW(D1:D250));21-ROW(INDIRECT("1:20")))))


2nd Formula

=INDEX(D1:D250;LARGE(IF(D1:D250>0;ROW(D1:D250));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!
Click to expand...
 
A

Antonio

Dave

Thank you very much for your pacience and help.

The formula does work. The problem was that when I originally tryed it, and
obtained a "false" message, deleted the contents os the first row.

Tks once again
best regards
Antonio
 
Top