Help me to understand formula

[paramveer]

=OFFSET($A$1,(ROW()-ROW($A$1)+IF(ROW()=1,1,-1))*IF(ROW()=1,2,1),COLUMN($F$1)-COLUMN($A$1))


i upload a excel file in https://skydrive.live.com/redir?resid=FF9C73CAE52F48A2!118


SirJB7 solve my problem. but i want to understand his formula because i applied on different sheet

 

[Debraj]

Please be patience..


Its a Sunday.. At-least for others..


http://chandoo.org/forums/topic/how-to-set-formula-for-different-gap-in-source-and-destination#post-106316


Regards,

Deb

 

[paramveer]

Sorry


I Send my Question in tommorow

 

[Faseeh]

paramveer,


i am unable to find this formula in your uploaded book. Please check.


Regards,

 

[bobhc]

paramveer


You have already asked this question in this post


http://chandoo.org/forums/topic/how-to-set-formula-for-different-gap-in-source-and-destination


and Debraj Roy has done lot to help you understand the formula and point you in the right direction for further information.


Multi posting to try and get answers quicker is frowned on, it was pointed out to you in the previous post that forum members have their life to live out side of Chandoo.


You come over as a very impatient person who wants answers now!!!!...


Members will help you but respect them and their commitments.

 

[paramveer]

https://skydrive.live.com/redir?resid=FF9C73CAE52F48A2!119


Faseeh follow this new link

 

[Faseeh]

paramveer,


Please elaborate what do you want exactly, this sheet contains just few cells with formulas. Do you want A13 to be 57?? If yes then i request you to post your comments on original thread. I will post my solution to the at thread as well.


Regards,

 

[paramveer]

Faseeh


you're right Sir. I A13= 57 i.e f9.


https://skydrive.live.com/redir?resid=FF9C73CAE52F48A2!120


will you tell me the meaning of thread.