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!
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top