# sequences

1. ### Excel formula

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...
2. ### IF and MID and ELSE

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...
3. ### Determining Next sequence of number if there are 7 sequences each starting with a letter

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...
4. ### random numbers from 4 different sequences into one

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...
5. ### Highlighting the last number in sequence based on the same order number and due date

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...
6. ### Order of Looping Through Files in Folder

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...
7. ### New to VBA - create a loop numbered 1 to 9 based on criteria

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...
8. ### Non Repeating combinations of numbers (1-6 from 2 to 6 used)

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...
9. ### VBA - Move PivotItem to last position in sequence

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...
10. ### finding a 3 NUMBER SEQUENCE, And displaying which rows it occurs in.

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...
11. ### FINDING MULTI-NUMBER SEQUENCES, identifying the rows they occur in, LISTING THEM

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...
12. ### Macro for finding a relationship/patterns for excel forecasting and prediction.

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...
13. ### how to create a sequence of combinations of numbers in excel

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...
14. ### Apply formula to an entire column

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...
15. ### Alphanumeric Sequence Autofill Options?

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...
16. ### Excel Macro to open Excel sheets in various sequences

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 &...
17. ### Excel 2010: How to have different sequences in a single column.

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...
18. ### formula to expand ranges

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

### This Week's Hot Topics

• Copy entire row if CountA <>0 to another sheet
[B]I want to copy entire row if CountA <>0 for column J7:AM7 (headers on J6:AM6) and so on till the last used cell is column D and paste the...
• Select last used Row in Table
I have created a Table in a Worksheet which is locked to prevent user errors and protect formula. Some of the cells require freetext entries which...
• excel workbook: do not allow certain file name
Hello all, Don't think this has ever been asked before, but how do I restrict file save [Before_Save Event] if the name of the file being saved...
• fixing problem autofilter
hello i need help about my code when i search by code in textbox it doesn't show anything this is my data [ATTACH type="full"...
• “Weight”
Hi, i’ve got a long sheet filled with weights such as kg,g,L & ml. i can build a formula to convert kg into g and liter into ml. How ever, my...
• How to capitalize everything before a certain character?
In column A, I have some text: Hello good day.mp3 Hello good day.flac etc. I'd like to capitalize everything before the period. I don't need the...