• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

microsoft excel 2013 [SOLVED]

paramveer

Member
In Excel, if I copy a cell containing a formula down the column to copy to adjustment rows, i need formula increase sequentially for example if a1 = 5, a2=2, a3= 4 and then i use coloum no. m4 =a1 i.e. 5 but when i copy m4 paste it on m6 the result is m6=a3 i.e. 4 but i need m6=a2 how can i copy formula
 
Good day paramveer


Welcome to the forum perhaps you should take time to read this,


http://chandoo.org/forums/topic/phd-forum-posting-rules-etiquette-pls-read-before-posting


The answer may be important to you but the forum members have a lot to do in life as well as helping to answer questions.


Have you used absolute cell references to lock your cells into the formula, M4=$A$1.....M6=$A$2.....This link explains all,


http://chandoo.org/wp/2008/11/04/relative-absolute-references-in-formulas/
 
Paramveer


Firstly, Welcome to the Chandoo.org Forum


In M4 put: =OFFSET($A$1,COLUMN()-COLUMN($M$1),0)

Copy across as required
 
http://www.4shared.com/file/_9-kYMM2/question.html


Sir please see this file and troubleshoot my problem


I shall be very thankfull for this
 
Hi Paramveer ,


Please note that sites such as 4shared.com require the person who wants to download the file , to log in ; this in turn means one has to sign up if one does not already have an account.


Please avoid such websites ; a site such as 2shared.com
does not require an account in order to download ; use such a site to upload your file.


Narayan
 
Paramveer


You post a comment like "please answer this i need a most"

and then don't respond to my post to tell us if it works or not ?
 
sir i does not work.

i give you link for the question is :

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


2shared also require ID so i use skydrive.


Sorry to disturb but i shall be very thankful for this
 
In F4: =OFFSET($A$1,INT((ROWS($F$4:F4)-1)/3),0)

Copy down to F7, F10 etc
 
https://skydrive.live.com/redir?resid=FF9C73CAE52F48A2!114&authkey=!AEc_8LRb-ZuMLOk


Now please see this file and give me formula
 
Hi Paramveer ,


Try this :


=OFFSET($A$1,(ROW()-ROW($A$1)+1)*Separation,COLUMN(Start_From)-COLUMN($A$1))


where :


Start_From refers to $F$4


Separation
refers to 3


Narayan
 
Thanks sir. It solve some of my problem. But can u solve this problem also


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


I shall be very thankful for this.
 
paramveer


You seem to be posting different questions in the same post, how are forum members to know this, they may have visited the original post, read it and thinking that all the posts refer to the original post will not re-visit to help or members will not be able to learn and understand from the answers.


Even though your question may refer to the same workbook it is always best to ask new questions in there own post so that all members may take part if they wish.


A clear title as to your problem would help forum members to understand your needs, your title to this post could mean a problem amongst thousands
 
Back
Top