sequence

  1. M

    PowerQuery > create a modulo sequence

    Hi I am trying to consolidate about 30 documents into this one master database with Power Query. When expanding all my tables, it seems like the Item column isn't populated for some of the documents. The Occupancy(%) column is organised in a sequence of 5 items for 3 KPIs. > I would like...
  2. P

    Pull the subsequent data for repeat values (Vlookup/Index - Macth)

    Hi, I have a large data set with more than 15k rows. in one file (Say: File A) there is an SKU and Bin Location for all rows. And in the new file that I'm now working (Say: File B) contains the SKU number and I require to pull the corresponding Bin location. The challenge is that in File A both...
  3. S

    Multiple Cell Check without VBA

    Hi, I have an hard time being able to figure out a solution to my issue and would like to see if anyone can help or has ideas of how this challenge can be resolved. I am trying to find a formula that is able to tell me if a cell has changed from a number to a text (horizontally) resulting in...
  4. DRSteele

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

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

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

    Sequence Function

    I am not sure this forum is the right place to ask about this. I use Excel 2013 and have been looking for a downloadable add-in of the sequence function. Is there such an add-in? If so where can it be found?
  8. D

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

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

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

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

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

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

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

    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!
  16. A

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

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

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

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

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

Some videos you may like

This Week's Hot Topics

  • populate from drop list with multiple tables
    Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
  • Find list of words from sheet2 in sheet1 before a comma and extract text vba
    Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
  • Dynamic Formula entry - VBA code sought
    Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...
  • Listbox Header
    Have a named range called "AccidentsHeader" Within my code I have: [CODE]Private Sub CommandButton1_Click() ListBox1.RowSource =...
  • Complex Heat Map using conditional formatting
    Good day excel world. I have a concern. Below link have a list of countries that carries each country unique data. [URL...
  • Conditional formatting
    Hi good morning, hope you can help me please, I have cells P4:P54 and if this cell is equal to 1 then i want row O to say "Fully Utilised" and to...
Top