sequence

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

Hello, I have been tasked with using excel to create a macro to auto-populate and generate the next 100 numbers based on values entered, after this is generated I would also need the functionality to be able to hit print and the Sticker Printer Number Convention should be: eg: LP011000000000...

Hi, Is this possible to detect this kind of sequence in 250k-750k row data. 1) Count start at least the sequence of up-down 2) Stop the count if next value is not in squence of, increasing(up)-decreasing(down)-increasing(up)-decreasing(down),.... , example: i- up-down->down ii-...

Although this is similar to other resolved posts, I was unable to find one that matches my specific need. As the title states, I need to be able to specify a starting string, and increase the sequence by a specified number. For example: If starting string is AA and The number to increase by is...

I'm trying to create a row of numbers from an existing table and transpose the associated column numbers into the new sequence. There are over 300 rows in the existing table to convert. Thanks. Existing Table: 1000 100 100 50 75 55 1001 0 20 30 40 0 1002 30 40 0...

Setting Suppose I want to have the numbers from 1 to 10 generated in the range B1:B10. I can store N in A1 and type =SEQUENCE(A1) in B1. A dynamic array is generated that gets the job done. My problem I have an arbitrary computation in A2 that I want to copy 10 times in the range C1:C10. I...

10 years + Excel experience and consider myself to be 'advanced' but can't crack this one for the life of me! All help is greatly appreciated. See attached spreadsheet.... I have a cumulative tracker of 'packages sold' in row 54 and 55 (in green) In row 71 and 72 (in yellow), I would like to...

Hi everyone, I'm so excited to join this group. I recently watched some videos on the dynamic array function in Excel and I think this is gonna change a lot of things. I'm looking forward to learn more from all of you. Here is my problem: As the pictures show, Table 1 is a simple...

I have an example I would like to make a reality with a formula for Column C. In Column B, I have used a formula to create a naming convention using Column A (check the formula bar in the picture above for reference). Column C is what my desired result should be at the end. I have just typed...

File: Dynamic Column Identifier Formula.xlsm I created this formula to dynamically return the column name based on the corresponding column number. That said, it works intermittently once you get to Column AA. I could understand if it was broken completely at Column AA and beyond, but I cannot...

hi, In column B1 I have =sequence(1,36,1,1). This gives the months for 3 years. In B2 i have some date which starts at 10 and increases by 3. =sequence(1,36,10,3). great. But every year in month 9 i want to add additional 7 and then resume adding 3. So the first graph shows what I have...

Hello all, The SEQUENCE function is new in Excel. It can be very useful, certainly when we use it as input in other functions. (MrExcel has a cheap e-book on the topic of the new dynamic array functions) Now my question: SEQUENCE generates a sequence of numbers row by row, and on every row...

My workbook contains an 'inputs tab' where i will have 3 inputs: "date", "amount" and "number of months." In my 'output tab' i have row 1 filled with all the month end dates. I.e Jan 31, 2020, Feb 28, 2020....etc I want to have a dynamic formula in row 2 that will match the "date" from...

Hi, My interest value for the data is "0", zero. The value 0 must be the most appear in sequence. (sorry for my bad english) Example: ________| Column A Row 1 : 2 Row 2 : 0 <- Row 3 : 3 Row 4 : 0 <- Row 5 : 0 <- Row 6 : 0 <- Row 7 : 0 <- Row 8 : 4 Row 9 : 0 <- Row...

I need help figuring out what function to use in order to assess the accuracy of a mock draft based on a point system I found online. I created 2 sheets: Sheet 1= which contains the actual results of the upcoming NFL Draft (which I will update as picks are made) and Sheet 2= the predicted...

The new Excel function SEQUENCE seems to be producing errors. I want a sequence of values from -50% to 50% with a 5 point step. Put this in a cell and evaluate it in Edit mode by pressing f9. =SEQUENCE(21,,-0.5,0.05) Not only is the 0 a wonky exponent, some of the other values near zero are...