-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
increment cell value
-
J
Incrementing a formula by more than a value of 1 when dragging down a row
I have an Amortization table in a sheet that has 360 rows and one of the columns shows the interest payment each month. In a separate sheet I have 30 rows which represent 30 years. I have the following formula in one cell to sum the first 12 months of interest: =sum(Amortization!D6:D17) as...- jeffdlinn
- Thread
- increment cell value
- Replies: 10
- Forum: General Discussion & Other Applications
-
J
Increment number to return to 0 or number after the last sheet created
Good afternoon all! I've been trying to tweak this code, based on other posts i saw around, similar to this situation. I use the macro to copy/paste the template sheet and it names the new sheet according to a code and the number it stores on cell H2 of the template. This number increments but...- jo_hivera
- Thread
- add 1 auto increment number copy and paste new sheet increment cell value increment cell value by 1 increment number worksheetcopy
- Replies: 8
- Forum: Excel Questions
-
O
Excel VBA Cell format - Increment number format
Hi All, Firstly, thank you for your time helping me with my query. I used Bill Jelen's "Next invoice number" VBA code to help set me up with an invoice template that will generate a new blank invoice and add 1 to the invoice number. My issue is that I have set the first invoice to "SI-00001"...- oO P2K Oo
- Thread
- cell formating increment cell value invoice number vba
- Replies: 3
- Forum: Excel Questions
-
R
Grab first three letters of word & Index until different
Hey All Its easy to do this in Excel but Access apart from the general stuff to me is difficult. Basically I need to create Unique ID's for requirements. Each requirement has a program and the requirements are based on the program. There is a field(record) in the table for Program, so What I...- Rude Awakening
- Thread
- access goo increment cell value msn yah
- Replies: 2
- Forum: Microsoft Access
-
E
Number rows but reset after a blank cell is encountered
Hi Excel gurus, I have the following formula which assigns a number to a cell =IF(E2="","",COUNTA($E$2:E2)) It works great however I have a small issue in relation to when a blank value is in a cell, I'd like for the numbers to reset to 1 and increment (instead of continuing to increment...- excel_2009
- Thread
- increment cell value increment cell value by 1 reset
- Replies: 5
- Forum: Excel Questions
-
L
Formulae needed to calculate cattle herd growth projection!
Hello everyone! Help! :confused: 1. There are 61 cattle due to give birth in 2016 and then one calf per year thereafter. 2. There is a 45% chance of those calves being female. 3. Of those calves being female, they too would be in a position to reproduce once two years old, again having a 45%...- Lady K
- Thread
- formula increment cell value increment formula
- Replies: 1
- Forum: Excel Questions
-
Z
How to increment cell value with IF condtion?
Hi everyone! I'd be greateful if anyone can help me on this complicated query. Maybe easy peasy for you :confused: I'm a structural design engineer and I want to develop my own spreadsheet to calculate required area (mm^2) of reinforcement bars in concrete to avoid concrete cracking due to...- zakmuh
- Thread
- if condition increment cell value macro vba
- Replies: 15
- Forum: Excel Questions
