incremental

Hi all, I'm trying to create a way to sequence rows automatically but cant seem to find the smart/short way for it. So far i am able to build the way to sequence the Primary rows, and the secondary in a different column. My problem comes later when trying to concatenate them or put them...

I have a spreadsheet that has a tab with sections and within each section there will be tasks added – each task item requires a unique number and must increment to the next available number within a specified number range based on a Work type. The first 2 parts of the number are based on two...

Hi Guys Im trying to make a Loop function for the following I want to make the payPer iterate so payPer1, payPer2 etc. Any idea how I can do this? cheers. pmtCount = 0 incremental = 0 x = 1 Do While pmtCount < 20 Cells(Rows.Count, 22).End(xlUp).Offset(0, 0).Select ActiveCell.Offset(0...

<tbody> Hi, First post and struggling to add a snip even! Currently using Excel 2007. I need to automate the process of calculating the incremental mean temperatures ( highlighted in red font ). The source data is from a thermometer that records hourly as shown in the right hand columns. If...

Hi I have a waterfall chart with 5 metrics. But I'll use 2 of the metrics (see below) to simplify the question: <colgroup><col><col></colgroup><tbody> Baseline Sales Incremental Sales 10,000,000 5,000,000 </tbody> Question: when using a waterfall chart, if the baseline sales are $10m...

Hi, Need formula to calculate sales commissions on incremental value. Thanks

Hello guys Please help me with this question. 10000 10% 12500 15000 17500 20000 22500 25000 7% Above I want to distribute percentages incremental, to decrease between 10%-7%. There is one formula for this. Thanks

Hi there! I would really appreciate your help with creating a formulae which will achieve the expected IDs below. Each time Level = 1, the counter for Expected ID should reset to 0 and start to increment by 1 again. <tbody> Level Expected ID 1 0 2 1 2 2 2 3 1 0 2 1 1 0 1 0 2...

I have date that always increments everymonth by 1 and max number 12, as there are 12 months in a year. Sometimes this number will be max of 6. So, I am trying to figure a formula out that would, on the first of each month increase that number by 1, and on the 13th month the number will go back...

Hi all, I am looking for a simple function. I have managed to break it down into small chunks but not getting anywhere with it. When the macro is run it looks at a table and increments the ID when it adds a row. <tbody> ID name D-1 Bill D-2 Ben </tbody> I can add the row but cant...

I am trying to find the frequency of lottery numbers that occur within 10-day periods (see row 7). Instead of having to manually write each formula for each column, is there a way I can automate it, so that each column will "advance" 10 days? Excel...

Hello everyone, I am trying to figure out if there is a way to continue this as a sequence without using a macro: =A5 =A10 =A15 =A20 =A25 and so on... And if there is a way... would it also work with this: =SUM(A5:A10) =SUM(A11:15) =SUM(A16:A20) =SUM(A21:A25) and so on... Any help would...