Thread: Blank cells
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Antonio Antonio is offline
external usenet poster
 
Posts: 134
Default Blank cells

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