auto increment

  1. R

    Auto Increment

    I have this formula, =SUMIFS($D30:$D100,$C30:$C100,4,$F30:$F100,2), where I want only the number 4 to increment when i drag across a row. I am unsure how to make this happen. Heath
  2. bs0d

    Calculated Table Field

    Is there a way to create a calculated field which auto increments by unique ID's in another field? For example, see CalcTime in the data set below. Starting with 1, it numbers each row until the PROP changes and starts over again. ID---- PROP---date-----CalcTime 1----- abc---1-Jan----- 1...
  3. T

    Increment alphanumeric column value by 1

    Hello, I'm using Excel 2007 on a Windows XP box for creating QA test cases. I looked through the forum and haven't found an answer to my question. I need to be able to auto increment my test case ID in column A by 1 when I hit 'Enter' or click on the next row. I.E. The test case ID value in...
  4. B

    Auto increment a specific cell value based on a different but related cell value

    Ok, I'm a VBA novice so please bear with me! In my excel workbook, I have a customer table and invoice sheet among many others. As part of my system, there is functionality to grant new customers with a discount on the first purchase. Within my customer table, the last two columns are "Number...
  5. C

    Prevent Auto Increment when extending cells down

    Hi everyone, I have a spreadsheet that contains a date column (formatted as date). When it gets populated, users have a tendency to drag that value down to fill some of the rows beneath it. When they do, the date auto increments. Is there a way to prevent this other than asking all my users to...

This Week's Hot Topics

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
Top