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...

Some videos you may like

This Week's Hot Topics