I am trying to make formula so it looks up the cell on the left and add +1 in it cell and then the next cell would do the same.
I am trying to make formula so it looks up the cell on the left and add +1 in it cell and then the next cell would do the same.
Assume the cell to the left is A1, then the formula in B1 will be =A1+1, then the formula in C1 will be =B1+1, and so on.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Thnx i understand that, but what i am trying to make is formula that would do that without me typing it in manually.
Let's assume i need to make a row with 300 inputs, im looking for one formula so i can just paste in all of them.
Something like =A1+1 turned into =(-1)+1 where (-1) would say look up value in the cell left of it.
Please attach a sample workbook. Make sure there is enough data to demonstrate your need. Make sure your desired results are shown, mock them up manually if necessary. Remember to remove ALL confidential information first!!!
Click on GO ADVANCED and use the paperclip icon to open the upload window.
The paperclip icon
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
Practice.xlsx
Sorry This might be more complicated than i thought.
What im trying to do is to make calendar, if you check the file i have already done so it auto generates the dates but i want to make that formula so i don't have to enter manually.
I understand that typing 30 cells in manually aint that hard, but i am trying to learn excel and i usually do best by practice so i appreciate any help thnx.
Last edited by kris_; 10-04-2015 at 12:14 PM.
I am a bit confused about what you want, but try this in B6 and drag the formula to the right:
=DATE (A2,TEXT (A1,"mm"),COLUMNS ($A:A))
Sorry the one i uploaded was a bit old file. what i have in B6 is =DATE(A2,A1,1)
And it works it generates the days and dates according to month that is chosen in drop down menu.
in C6 i have =B6+1 and it adds the next day and date
What i am trying to make is a formula so i dont have to type =B6+2 =B6+3 in each next cell. Surley there should be a formula i can apply to each cell to do that manually.
Hope you understand.
So did you actually try thr formula that I suggested? I am having problems attaching a file onto the forum site right now.
On second thoughts -it's incorrect.
Use this:
=DATE ($A$2,$A$1,COLUMNS($A:A))
Ohh yeah it did work, care to explain why ?
Sure. The first bit is the same as yours. The ladt bit - the columns bit - is simply a counter. A:A resolves as 1; A:B as 2, etc.
Thnx for the help will read upon columns function and arrays.
Glad to have helped... albeit eventually! If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. It'd also be appreciated if you were to click the add Reputation button at the foot of any of the posts of those who helped you reach a solution.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks