1. staticfluids

    Distribute Number into Several Part (Increment) Based on Other Data (Dynamic Array)

    Hi all, I hope you're doing well. First of all, sorry for bad explanation as my main language is not English. I'm currently using Excel 2021 and trying to experiment with Dynamic Array formula. It's quite helping with my daily Excel use. 2 of my latest question was asking about Dynamic Array...
  2. F

    How to change column range incrementally as row cell is dragged down?

    Hello all, I'm trying to figure out how to change the column range incrementally as the cell in column N is dragged down. I'm a little stuck. The highlighted cells per row should equal the value in column N. The range length stays consistent but moves one to the right as the row moves down...
  3. G

    Trade Summary - Incremental Lookup / counting

    Hi Gurus, I've run into another thing I can't quite figure out. In the attached mini-sheet, there are columns with an example date, stock price and buy/sell that takes place. The columns to the right are what I would like to achieve dynamically where, each buy/sell pair equals a trade which is...
  4. M


    Hi Everyone! My goal is create a column called "Counter" which keeps track of the number of times OBX appears in another column called "Segment_String" Segment_String Counter OBX123123 1 OBX214313 2 NULL 2 NULL 2 OBX123443 3 NULL 3 NULL 3 NULL 3 Your help would be...
  5. I

    Quick solution for 400 increment macro's with VBA?

    Hello community, Excel/macro noob here. I have a question. currently i am working on a 'barman list' in excel where the barman can click the + and the - to increment or decrement a value. For examle, "john" orders a drink, the barman clicks the + button behind his name and a 1 will appear. I...
  6. Z

    Drag dwon formula increment cel value larger then 1

    Hello, I have a simple problem that I cannot get to work... Problem I have one list (vertical in one column) with data. I want to create a second list (vertical one column) with a drag down formula that takes only every (for example) 3th value from the 1e list. What did I do to solve it I...
  7. M

    assign Incremental numbers in new column based on criteria from two columns

    I am looking for assistance in setting up a formula to return incremental values to a list (including duplicates) only when selected values are present in a different column. Please see the example attached, if the produce is apples, banana or peach assign the number (1,2,3) representing the...
  8. K

    help with customer AutoNumber

    I need help with how to setup a custom AutoNumber in Access. I want to be able to enter a starting number with up to eight digits and then have it increment by one. So, for example I want my starting number to be 30064889 and increment from there. Is this possible?
  9. D

    Increment value of cell if another cell changes value

    Hello, Is there a way in Macros or VBA to increment the value of a cell by 1 if another cell changes value? Ill give the example: In cells A1 to A56 I have links to another workbook that update every few seconds. I would like to count in Column B -- B1 to B56 -- The changes from each cell...
  10. O

    Auto increment two cells with userform

    I am trying to figure out to have two cells increment after creating a record with my user form. My form is simple where I have a button that will create a row every time it is clicked. After clicking the close button the data will sort from highest to lowest trace number. Lets say for example...
  11. D

    how to increment numbers in a range and ignore blanks

    hello, i am trying to increment the cells that hold a numerical value within a range whilst ignoring blank cells. i am using the code below, but it has no affect: Set cellrange = Range("M8:M44").Cells.SpecialCells(xlCellTypeConstants) For Each cell In cellrange cell.Value =...
  12. S

    Increment alphanumeric string by 1 for each cell in Excel issue.

    Lads, i have formula in cell A2: ''=LEFT(A1,4)&RIGHT(A1,4)+1'' that increments next cell by 1. Problem is when number go over 1000 it looks like this: HMR01000, but I need it to be HMR1000 , HMR1001 etc. <tbody> A 1 HMR0500 2 HMR0501 </tbody> Thanks.
  13. 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...
  14. K

    How to increment data using two sheets in excel

    I have two sheets: sheet 1 contains a list of orders in ascending order. Sheet 2 is supposed to extract the last order number in sheet 1 and increment it by one. This is what I have come up with: <code style="margin: 0px; padding: 0px; border: 0px; font-style: inherit; font-variant: inherit...
  15. L

    duplicate an x amount of rows but with each duplication increment by 1 all the numerical values within the row

    Hi, I have the following problem and not sure how to go about doing this. I have the axample below" <colgroup><col style="mso-width-source:userset;mso-width-alt:2816;width:58pt" width="77"> <col style="mso-width-source:userset;mso-width-alt:3730;width:77pt" width="102"> </colgroup><tbody>...
  16. L

    Incrementing year by 1 if week number is 27 but only triggering once a year VBA

    Hi, I just can't get me head around what is probably an easy solution. The code below is a date inputter into a sheet that on workbook open but only triggers if it's a new day. It inputs the current season, year, week number and day. What I need is for when the week number gets to 27, the year...
  17. J

    Do While & Number Advancing

    MrExcel forums to the rescue again - furthermore, I always give full credit back to the forums when folks ask "how did you figure that out!?" Cell B1 contains a number, we'll say "25"; I would like to increment the number in cell A1, beginning at "1" until it reaches the equivalent of B1 then...
  18. K

    Leading Zeroes in a List

    Hi All, I am trying to create a list of numbers in one column. My list needs to have two leading zeroes. The problem is that once the list hits 10, it takes away one leading zero. For example, excel does this:001 004 ... 009 010 011 ... 099 100 101 I would like the list to increment...
  19. T

    Increment through range with VBA

    Hi, The code below is supposed to iterate through a range, so x starting from row 16 through to 25 and y to control the column increment from 5 to 13, i.e. E to M. The line highlighted in red is incorrect, can someone advise how this should be written or a different approach please? For...
  20. N

    Increment Number in a column every time a cell changes color

    If I have a column where some cells are blue and some are white, I want to start at 1 and increment by 1 only when the color changes in the cell below it. If a cell changes colors again, I would like to increment by 1 again all the way to the bottom of the column. Could someone point me in the...

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