frank kabel- help me.

K

kumawat_s

a long back i have put a problem I had sent to you a example file
(unfortunately i have missed) and you have suggested OFFSET function. I
have applied this as below

=OFFSET($E$35,0,(ROW(1:1)-1)*2)

it is a great function for me. but now it is creating a problem.

after some row (in some sheet on row 44 and in some sheet on 58) the
values are displaying.

PLEASE HELP ME. A EARLY REPLY IS SOLICITED.

thanks in advance.

s karan
 
F

Frank Kabel

Hi
check that automatic calculation is enabled ('Tools - Options - Calculate')
and also make sure that you really have data in the referenced cell (every
second column)
 
Top