sequence

SR# (Column A )J# FROM (Column B)J# TO (Column C) 19660496606 29656096586 39655596559 49653896539 59654096542 69653096537 79637596384 89638596427 99642896457 109645896465 119649796521 129652596527 1396529 149654596551 159646696490 Hello, Need formula to show...

SEQUENCES is a powerful and versatile multi-SEQUENCE solution providing full control over "start" of each sequence as well as each of the "counts" and "steps" and having other useful features such as stacking and sorting The overall function parameters are similar to the native SEQUENCE...

Good day, I have a table that needs to count the sequence. Problem is formula to get the count in order -> VW, FW, SW, FWW, NTE If the order is correct should have count as 5 But if when it went back to VW count should be 1. Every time it goes back to VW it should count as 1. The count...

Hello, Here is a rather complex sequence question 😀 Suppose I have the following partial LET function: =LET( b, {2,1,3,4,2}, c, 12, operation ) The numbers in b indicate the count of numbers in each piece of the final sequence. The first piece starts with 1, and each piece after the...

Hi all, i hope you're doing well. First of all, sorry for bad English. I'm currently using Excel 2021 and trying to experiment with Dynamic Array formula lately. It's quite helping with my daily Excel use. I have a one case where i want to divide its own cell using a value from another cell...

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