increase by 1

  1. C

    Formula based on Highlighted

    I have a number of cell that are highlighted, I want to create a formula, that will produce a number based on if the cell is highlighted in increasing order, See Below: THANKS!!
  2. T

    Insert increasing number into adjacent cells with the same value

    Hello everyone, I have a column with values either 0 or 1. Everytime there is one or more 0 below together, I need them to be replaced with increasing values by 1 and do not change the lines with previous 1. Like this: 1 1 /*no change 1 1 /*no change 0 1 /*+1 1 transform...
  3. I

    Increase value in a second spreasheet

    Hi, got this code to increase value by one (same position, row and column, of the active cell) in a second spreadsheet ("foglio2")... Sheets("foglio2").Cells(ActiveCell.Row, ActiveCell.Column) = ActiveCell.Value + 1 but it doesn't work cause it only count 1 in the second spreasheet, doesn't...
  4. A

    Add an increasing Number to each instance of a String

    I have a project that imports several text files into a spreadsheet, and I am in need of a way to identify the beginning lines of each file. Doing this will allow me to separate the bunch into separate columns later on. So, Each file begins with the word "Sample" and I would like to change...
  5. E

    Increase Cell by 1 if another cell changes to a certain value using macros

    Private Sub Worksheet_Change(ByVal Target As Range) If Target.Count > 1 Then Exit Sub If Target.Address(False, False) = "C2" Then Range("F2").Value = Range("F2").Value + 1 End Sub I am using the follow macros code when I right click my spreadsheet and enter...
  6. Z

    How to Increase Part of a Cell Value Using a Macro

    Hello, I'm am trying to increase part of the value of a cell using a macro. The formula is very complicated, so it takes a long time to edit manually. Here is what I would like it to do: Input cell value...
  7. S

    How to repeat date in column then increase

    HI there! I hope someone can shed light on this what I thought would be simple task. I have some data entry to do and I have 9 entries with the same date then go on to the next day. I am working with excel 2007 and 2010, so I would like it to be compatible with both. Column 2 is repeating...
  8. L

    Autofill Macro Help

    I inserted an image which looks like "+" and assigned it the following macro -> Sub IncreaseByOne() Range("B2") = Range("B2").Value + 1 End Sub It increases the value of the "Quantity" by 1 each time it is clicked. Now i want to apply it on the rest of the cells. Autofill doesnt...

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