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 *0.00* *whereas values are something else.*
PLEASE HELP ME. A EARLY REPLY IS SOLICITED.
thanks in advance.
s karan
(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 *0.00* *whereas values are something else.*
PLEASE HELP ME. A EARLY REPLY IS SOLICITED.
thanks in advance.
s karan