i want to drag vertically the equation in the third column of data and the result required is as the second column of data. ( cells are droping by five).I am refering to the second page (page2) of excel book.
Could anyone please help me into this? Thanks a lot!
Last edited by nickgeo; 11-01-2012 at 07:03 AM.
Type this in B2 and drag down..Formula:
=INDIRECT("page1!C"&2+(ROW()-2)*5)*100/INDIRECT("page1!C"&1+(ROW()-2)*5)
thank you .....you have been very helpfull. Could you explain the formula, if it is not so much to ask, so that i can adjust to similar problems.
The only addition i have given to your existing formula is (Row()-2)*5. Row() function returns the row number of the existing row. So, in B2, it is (2-2)*5=0. In B3, it will be (3-2)*5=5. For each subsequent row, 5 will be added. And that is your requirement.
my initial thought was to drop the actual cell as it apears in the example page 2 column B (c2/c1 then c7/c6,c12/c11 and so on you have a visual of the changing cells). You gave me an other way of thinking, that is quite usefull and it works, but it doesn't fulfill my need completely. Do you have any other thoughts on how to actually see the cells involved in the equation escallating by 5?
Either way you have being very helpfull.
Do you want to verify if it is referring to the correct cell? I do not know any other way of displaying it in the same cell. You can use supporting columns.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks