sequences

I am preparing a cashflow model which has a column with years starting at say 2023 going on for several decades. I wish to make a periodic income in the adjacent column that starts in say 2025 then repeats every say 3 years. Could someone help construct a formula for this? The start year, the...

Can someone kindly help me figure out the formula for the following case: If the cells A1 to A100 contain values 1 to 100, what formula should be in cell B1 so that when copied and pasted to cells B2 to B100, it will produce the following sequence: B1 = 1, B2 = 2, B3 = 2, B4 = 3, B5 = 3, B6 = 3...

Could someone please help me to add multiple functions in a search string? =IF(MID(B18,2,8)="01330701","11-13 hours","") is giving me the desired result for that one formula. I need to check B18 for 5 different number sequences which would return the same, "11-13 hours" result if met. For...

Hello, I am looking for a formula that can determine the next sequence of a number from another sheet if there are 7 sequences each starting with a letter. For example: A001 B001 C001 D001 E001 F001 G001 I know that formula: =MAX('Sheet1'!A$1:A$1000000)+1 works to find the next sequence of a...

I have 4 different check # sequences. I do a % of the total number of Checks based on the total. I then used the # of items to select, of each of the sequences to = my total sample size of 25. My question is, how can I get the random # to select and then put them all together to give me my 25...

Good Evening, I have a workbook that contains a list of orders amongst vast other information. These orders may have 1-100 lines(sequences) against them but split into multiple due dates with further sequences listed as a later due date. As we anticipate the first order of the first five...

I have a sequence of code in an Access Application that loops through files in a specific folder -- using For/Next: For Each File In Folder.Files Code Code Next My question is -- what is the order that it sequences through the files, is it alphabetical? Date Modified? Is there a way to...

Hello everyone, I'm new to VBA coding and trying to create a loop to number years, months and days 1 to 9 based on a specific start date. <tbody> A B C D E 1 Year Month Day Day Name Date 2 1 1 1 Monday 22/09/1980 3 1 1 2 Tuesday 23/09/1980 4 1 1 3 Wednesday...

Hi, I am trying to find a way to identify and display the combinations of 1,2,3,4,5,6 using 2 numbers, 3 numbers all the way up to 6 numbers, i.e. 2 numbers = 1,2 - 1,3 - 1,4 - 2,3 etc 3 numbers = 1,2,3 - 1,2,4 - 1,2,5 etc 6 numbers = 1,2,3,4,5,6 (I do not need 6,5,4,3,2,1 or any other...

Goodday all, I am trying to move a PivotItem to the last position in my Pivot table and found on the web below VBA code, but it doesn't work :mad:. Does anybody have an idea why? Dim total As Integer total = ActiveSheet.PivotTables("PivotTable1").PivotFields("Vehicle Type...

Hello, I'm trying to find out how to list which rows a number sequence occurs, in Column A, in a simple way, that doesn't make me search through a massive column in a workbook. I just want to see the rows it occurs in, without having to go down to those rows. The number sequence to find is...

Hi, I'm currently using =COUNTIFS(A1:A1000000,11,A2:A1000001,21,A3:A1000002,31) but I want to modify it to not only count the number of occurrences of 11,21,31 in column A, but to also list them by row. For example,,, .........A 25.....11 26.....21 27.....31 . . . 15000 11 15001 21...

I am wondering if its possible to write a macro that can find a relationship between columns in the worksheet found on the link below and make possible forecasts based on the relationship. https://www.dropbox.com/s/06hpjgcxuh61vkg/FIND%20A%20RELATIONSHIP.xlsx?dl=0 The worksheet has two...

As my final project for my statistics class, I want to prove that using a combination of the most frequent drawn lottery numbers can lead to a better chance of winning the lottery (Hot Numbers method). Now, the sequence ranges from 0-50 with only 5 numbers drawn. I will not use all of the drawn...

This is the formula list : <tbody> PV001/10/14 PV002/10/14 PV003/10/14 </tbody> The next sequence should be PV004/10/14. Currently, when i drag, the number will turn up PV003/10/15 instead of PV004/10/14. Is there any specific formula for the above - for me just to drag down the box...

Hi, I'm attempting to autofill an alphanumeric sequence in which the first half of the sequence repeats, only causing the second half to advance in sequence once a certain number is reached. The code is a two digit number followed by a two digit alphabetic code. The number portion of the...

Hello, I am trying to make macros to unhide hidden sheets in different sequences then its original sequesces. Example : I have sheets Control Sheet,A,B,C,D,E,F,G & H I want, i) Button 1 to hide all sheets apart from Control sheet and then unhide and display in following sequence - C,E,A,B &...

Hi i am trying to find a way to get different sequences on a single column according to the value on another column to the right of it. for example every time the value of the right column is "1" it adds to a specific sequence, every tiem its "2" it adds to another sequence. how could this be...

I have several entries in a column of data... example: t334.1 - t356.9 b044 - b059.7 w120.88 - w129.55 1036 - 1048 1044 2233 239 19 12567 H0876 I'd like to know if it's possible to "expand" these "ranges" to include the lines not shown (and represented by) the "-"... example 2: same list...