increment formula

  1. O

    Automatically insert an incrementing number, but allow manual override

    If possible, I'd like to have Excel insert a number that increments by one in the first column of every new row in a given table like so: GID FN LN 800 John Smith 801 Jill Rogers 802 Sam Spade 803 Sally Spade 804 Bill Bayes but that will also allow for manual...
  2. T

    Assign unique increment ID based on two conditions

    Hi everyone, I've always been a big fan of Mr. Excel's YouTube videos and thought I'd participate in the forum as well. My first post is in relation to the project I am working on. I am hoping somebody could help me out. Been searching for hours on the web and stumbled upon some possible...
  3. 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%...
  4. L

    Always increment to the next largest number in a series - even after sorting

    This answer may exist and I just don't know the right combo of Google search terms to find it because I've tried everything! I have a "to do" list and I want to add a unique index number for each new entry BUT I'm going to be sorting the list for due dates and priorities. How can I...
  5. M

    Increment a formula by row and column?

    I am trying to create a formula that will allow me to refer to the cell one below and one right of the column previously referenced (basically data in a diagonal line) in a new sheet in that workbook. Any help is appreciated--thanks! Here's a simplified version of what I'm trying to do...
  6. W

    Copy Worksheet while keeping incremental formulas

    In my workbook, I am calculating the collection of oil and water on an hourly basis and subtotaling on a 24 hr basis for several days/weeks in a row. I need the subsequent sheets after the first 24hr sheet to continue their formula and 'carry over' the previous sheets data. I've done this...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top