# sequence

1. ### All Permutations of Three Variables

In order to generate all the permutations for three variables, put the variables in an Excel Table (which is called Inventory here). You can add as many rows to the Table as desired and you can fill in all or just one of the rows for each variable. The exemplar here will spill down 60 rows, the...
2. ### Excel struggles to respond with certain formula

I enter the number 45 into cell A1. A2 formula: A1+1 (Returns "46") A3 formula: A2+1 (Returns "47") A4 formula: A3+1 (Returns "48") I have this sequence for about 200 rows. I understand that you are able to just drag down to continue the sequence of consecutive numbers although this is in...
3. ### Add Sequence numbers Based on Dates

I have one excel file where data is entered, and then transferred to another excel file with macros. On the second excel file I would like a macro that inputs a sequential number for each day in column A, and a sequential number for each week (or Month if week isn't possible) in column B. The...

5. ### Letter Sequence in Columns - AA AB AC AD AE etc

Hi, I have the following formula in cell K1 =LEFT(ADDRESS(ROW(\$AA1),COLUMN(\$AA1)+(COLUMNS(\$K1:K1)-1),4),2) I need to copy & past this formula 6 rows to the right each time (i.e. Q1, W1, AC1 etc) And return the following sequence in the cells; K1 - AA Q1 - AB W1 - AC AC1 - AD The formula...
6. ### Conditional formatting based on several cell values

Good day! I have dataset that looks like this (let's assume that "Name" is column A and "Sequence" is column B): <tbody> Name Sequence BUNNY 1 BUNNY 2 BUNNY 3 BUNNY 4 TIGER 1 TIGER 2 TIGER 3 TIGER - DOG 4 DOG 3 DOG 1 DOG 2 </tbody> I am in the need of a simple...
7. ### Determine Sequence

I have a list of Invoices with a Date and Email Addresses from a sales database. I have counted the number of invoices per email address...but now I need to mark each invoice as "First / Second/Third, Fourth, Fifth Order .. basically what sequence.... I am trying to calculate the number of...
8. ### Find Max value, then subtract based on several conditions

Hi All, I have the following data set: ID Sequence Type Time R0000039 0 Manual 03:11:45.014 R0000039 1 Manual 03:11:45.018 R0000039 2 Manual 03:11:45.441 R0000059 0 Manual 03:14:33.857...
9. ### Formula for autopopulating sequence numbers upon change in names

This site has helped me in years past and am stumped again. I have a spreadsheet of many rows. Column A is list of names Joe SMith Joe Smith Jane Doe Jane Doe Jane Doe Rick Smith Rick SMih I want to be able in column B to put in a sequence number so that both Joe Smiths end up sequence 1...
10. ### Conditional if in multiple rows and columns

Greetings! I have a question that I believe it should be fairly easy to resolve for someone with experience. I have a data set that looks something like this: <tbody> Run Order Sequence CAR 1 2 CAR 2 1 CAR 3 3 CAR 4 4 APPLE 1 2 APPLE 2 1 APPLE 3 3 APPLE 4 - SODA 1 1 SODA...
11. ### fibonacci sequence folmula

If you can do this , you are a genius!! formula for a roulette betting system in excel based on the Fibonacci sequence. The sequence goes like this: 1 – 1 – 2 – 3 – 5 – 8 – 13 – 21 – 34 – 55 – 89 – 144 – 233 – 377 – 610 – 987 – … You might have noticed (or you already knew) that each of the...
12. ### Saving a "Sort"

I have a standard report which I need to sort in the same way everytime. Is there a way to save the "sort" sequence and apply instead of re-creating each time? Thanks in advance!
13. ### numbers in sequence =IF(ROW()-ROW(A\$8)<=B3,ROW()-ROW(A\$8),"")

I would like to populate a value in cell say a9 to a50 based on a value in cell say g5 I want to populate cells from a9 to a50 based on the following conditions: the cell a9 will be 1 and the value cannot exceed the value in cell g5 assuming the value in g5 is 20, then the cell values from a9...
14. ### 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...
15. ### Repeat a value or number in a sequence multiple times.

I have a list say: A,B,C,D,F (IN COLUMN A) I want the user to select a member of the above list in column B1 and say how many times it must be repeated in column C1. The extracted list can now follow in any other column (a multiple of times say 2) Example. User selected A Repeat 3 List 2 times...
16. ### Add new rows and auto fill a sequence in them cells added

Hi all I'm wondering if you could help or at least suggest options. I have looked through loads of threads and have been able to add rows using a message box but I need to then autofill them cells added with a sequence. Sub MyInsertRows() Application.DisplayAlerts = False...
17. ### Count # of Sequences in a range

Hi there, I have a huge data set (10 units and 5 years data set) that contains for each unit an indicator whether a unit is fully or partially operational or zero if not in operation. I am interested to know the number of blocks (a block is defined as a sequence of fully or partially...
18. ### For Each Loop and Functions

I imagine this is painfully simple, yet all my research and trying to figure it out on my own has led to failure. I've learned how to create a button in Excel and create code in VBA to have that button change cell values. The problem is that right now I only know how to affect one cell at a...
19. ### Sum the same the cell from multiple tab

Hi all, I'm working on a workbook containing 150 sheets, 50 of which has "sales" in the sheet name. Is there a function that sum the same cell (like D3) of those 50 sheets? They are not in sequence, the 150 sheets are mixed up. Can we use a formula like - =sum( "'Sales" & "*!'" &"D3" )...
20. ### Find repeating characters in cell that are in sequence

Been trying to figure this out lately- I have excel data in a unique system where a cell has multiple values for SKUs For example 1231223525 123512AA12 bR1124ABAGGA i was hoping if there is a formula or a Sub where we can run it on the cell like MID(A1, (LEFT(A1)=",") + 1, LEN(A1)) to...

### This Week's Hot Topics

• Problem with Radio Button's format control
I am creating an employee evaluation template (a sample is below) Column A is the category Column B, C D, E and F will be ratings (unacceptable...
• Last Display on userform to a Listbox
[CODE=vba] lstdisplay.ColumnCount = 15 lstdisplay.RowSource = "A1:O600000" [/CODE] So when i do this it Displays everything on the sheet i am...
• Rename and move files to a new location
Dear all, I have an excel file with the following information. The actual file name is at column A but i want to rename it using the following...
• Help with True/False Formula
Hello! Am stumped how to fix this formula, in which my result returns 'True', but it should return False. =IF(AG2=True...
• Clear extra characters from a provided range of cells
Dear All, I have following code which gives me desired output to remove extra characters from a provided range. But it takes too much time when...
• Help with Current and highest streaks
Hi there, I've just joined the forum and this is my first post. I've already spent quite a bit of time searching the net and this forum for a...