Did you try to retype the formula? Safer to copy and paste, then you'll get
it right.
--
David Biddulph

"Antonio" wrote in message
...
Tks Dave

When I enter the formula the outcome is "False"

Can u pls help in correcting this??

Tks in advance

"Dave Peterson" wrote:

I selected E1:E20 and used this formula:
=IF(COUNT(D:D)<20,"not enough numbers",OFFSET(D1,COUNT(D:D)-20,0,20,1))

This is an array formula. Hit ctrl-shift-enter instead of enter. If you
do it
correctly, excel will wrap curly brackets {} around your formula. (don't
type
them yourself.)



Antonio wrote:

Hi all

Have numbers on column D, that are placed there by using the following
formula:
=IF(B14<=2,C14,0). This formula is copied down until the 400th row
(some
times more).

I am looking for a way (formula) to, in column E, have as result last
20
rows of non blank data.
I.E
B C D E
4 200 0 96
4 200 0 96
2 96 96 52
2 96 96
3 141 0
1 52 52

Tks in advace

--

Dave Peterson