sequence

Greetings dear experts I'm trying to create a macro to fill rows values from 0 to 9 starting at A1 and ending at A10, it also must populate B to E with the same sequence. I know I must use count and for function, and while to increase count value but I'm not being able at all to achieve it...

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

Does anyone know how to make a sequence of number as follows: Start between 1 & 15, increment either in 5 or 10 but always ending at 100? For example Start at 5 and increment in 10s: 5,15,25,35,45,55,65,75,85,95,100 For some sequences it's easy starting at 5 and incrementing in 5s as it can...

Hi I require a formula that checks dates shown on a row and sees if they are consecutive days, and return the quantity of consecutive days. If possible it also needs to discard weekend days, therefore Thursday 1st, Friday 2nd and Monday 5th will count as 3 consecutive days. Finally, each row...

In a data set, I'm trying to identify a way to lookup the first instance of a transaction type and its corresponding date and the first instance of a second transaction type (and corresponding date) that occurs after the first transaction type. In the enclosed example (click on image), in the...

Hi, I've been trying to make a list in excel that looks somewhat like this. Week 1 ...... Week 2 ..... Week 2 ...... Week 3 .... Week 3 .... Week 4 .... Skip Week 1 Week 4 ..... Week 1 ..... Skip But I've run amuck every single time. It's hard because i'm trying...

I have seen a discussion in the forum dated 2021 about this weird behaviour (bug?) of the function Sequence: Sequence(Randbetween(1,50),1) gives a #Spill! Error in Excel 365 most of the time. Sequence(A1,1) when A1=Randbetween(1,50) also gives a #Spill! error most of the time. I was hoping that...

Hi Mr Excel, Before I give data sample, let me explain the sequence pattern in picture and the criteria. Criteria of Sequence Pattern : (1) Must at least starting with postive number, follow by negative number. ( + - ) (2) Keep assign "1" the cycle until 'invalid' happen ( + - + - + - +...

Hi, is it possible to adjust the =SEQUENCE() formula so that only every second row is filled? I am trying to create a calendar within excel so that the dates automatically populate in the correct cell relevant to the day of the week. Picture attached. However the sequence formula spills...

Data dump fills out cells. In Column P the data will give the start time of certain shifts. Column AG will have a sequence of numbers 1 to whatever the total number of start times there is that day. Column AF fills out after macro is run to copy and paste the start times. Column Q returns the...

Hello, I would appreciate your help with the formula or VBA code for the following function. In the 'Used/unused item number' column I need to apply a sequence of numbers. If the item in the 'Used/Unused' column is 'Used' the formula should by order of 'Date' apply the sequence from the...

Hello all! I am new to programming in general, and I know very little of Excel VBA / macros. I need help inserting a sequential number from A6 to a dynamic number based on a previous number. Example: I have an initial number(B1) and a final number(B2), and finally, the amount between the...

I have been successfully using this formula: =UNIQUE(FILTER(pp_tasks,(wbs_Hire=1))) with great success to apply an auto filter to a set of unique values. In a certain use case, this data set is still too large and I only want it to return the first 200 values. This formula: = INDEX(...

Hi, I have a problem that I could use some help solving. I have an Excel workbook that calculate prices. The workbook has about 250 different products. All products are priced based on measurements, both width and height. The user enters the product number, number of products, width and...

Hello everyone, I'm trying to extract data from sheet1 into sheet2. One of the columns in sheet1 contains a personal identifier along with other text. On sheet2 I use a filter function to extract data from sheet 1 by referencing cells in sheet2 column (i) that lists the personal identifiers...

Hello, My situation is, I have meter readings that come in daily and are ever growing. Equipment is serviced based on the meter readings and the type of service depends on a sequence. Presently this is all done manually. My question is, if I have a repeating sequence of 16 services spaced at...

for example, I have 33 in cell A1, and 40 in cell B1, I want a formula in cell C1, to write an arithmetic sequence from 33 to 40 like this: 33, 34, 35, 36, 37, 38, 39, 40

I am trying to make a formula where I can generate the following variable sequence depending on the value in A1. If A1 = 2 the formula would cycle between A1,A2,B1,B2,A1,A2,B1,B2, and so on, but if the A1 = 5 it would cycle between...

Hello, I really need some help breaking down this formula please :) I currently have a document that I am working on where I have created a field that allows you to search for the relevant information below by entering in the postcode and the suburb. The screenshot below is a sample of the...

Hi there, I am banging my head against a wall trying to have a formula that would instantly count from 1 to 100 and then reset infinitely. I assumed I could do 1 to 100 twice and then use the fill handle but that causes excel to assume I want 1-100, 1-100, 200-300, 1-100 etc Now...