consecutive

  1. V

    Multiple csv file importer

    Hello, I am trying to come up with a macro that imports multiple csv files to different sheets and using the name of the file as the sheet name. I also need to be able to select the delimiter and also Consecutive delimiters. I have found 2 variants, one that imports multiple files but does not...
  2. MCTampa

    Grouping Consecutive Values by Min and Max

    I have the following table for which I would like to create groups of consecutive weeks by min and max values. <caption>Automatics</caption><thead> AREA Code Week </thead><tbody> 330 1 330 2 330 3 330 4 330 33 330 34 330 35 330 36 330 37 330 38 330 39 330 40 330 41...
  3. F

    Sum of highest 4 consecutive numbers and define the 4 numbers

    Hi everyone. I have a number spreadsheet with 20 columns /100 rows of numbers. I need to get the sum of the highest 4 CONSECUTIVE numbers of each columns. I have found two formula to get the sum: =SUMPRODUCT(MAX(D3:D95+D4:D96+D5:D97+D6:D98)) or =MAX(INDEX(D3:D95+D4:D96+D5:D97+D6:D98,0))...
  4. P

    Consecutive numbers IF

    Hello all, I was trying to use a formula to count rows that do not start with a number. Here all of the numbers that have a period should be skipped. I wan the other rows to count consecutive. With my formula, they skip the number that comes next. Could someone show me how? Thanks
  5. K

    Consecutive index match results??

    Hi, Does anyone know what I which additional formulas I would need to add/do to get this index match formula create a consecutive list of new matches as I drag the formula down to the next cells below So would like it to return the 1st match in one cell, then the second match in the cell...
  6. D

    Inquiry

    I have a bank of data that is updated monthly. I need to analyze said data to determine first all values above 35 then I need to look for two consecutive instances of this event. Once found, I would like to indicate for inspection if not ok
  7. M

    How to find out if rows are consecutive in a given range

    I need to determine if the cells that a user selects are consecutive, in terms of the rows. I have been trying to write a function to determine this (and return either TRUE or FALSE), but I am having a very hard time figuring out how to do it. I know how to get what cells the user has...
  8. L

    Eliminate sequential numbers

    Hello Friends, I have a complex problem that I need to solve. I would like to have the following results: Column A has 5 digit numbers. Of all the numbers that are consecutive in column A, I would like to have all of the digits that are consecutive deleted and print only unique...
  9. S

    Excel Function

    Hi everyone, Need help with a function/vba I have the following 5 numbers from 1 to 30 in ascending order: Notice below adding all the results would equal 5 (1-1-1-1-1 =5, 2-2-1-0-0 = 5, 5-0-0-0-0 = 5, 4-1-0-0-0 = 5, etc) 7 Possible Results 1-1-1-1-1 2-1-1-1-0 2-2-1-0-0 3-1-1-0-0 3-2-0-0-0...
  10. L

    Remove consecutive numbers

    Hello Guys, I saw this post here: https://www.mrexcel.com/forum/excel-questions/712373-how-remove-consecutive-number-string-only-column.html On how to remove consecutive numbers in a row, when I apply its suggestions I do not get any results. I am new to VBN, can anyone help me with a...
  11. S

    Identifying Trends by Date - Countif

    I have an extremely large data set by day for the last 6 months. I want to count the number of consecutive days where there was an increase in bill volume for the purpose of identifying the largest streak. For example, we continuously increased bill counts from January 1st through January 5th...
  12. M

    Find consecutive cells above a certain value, ignoring zeroes.

    I am trying to count the number of values in preceding cells which are greater than a certain value (in this case 19), but ignoring zero values. Put another way, I want to find the number of consecutive weeks that a staff member has reached target, but excluding holidays. I have googled this...
  13. C

    Average of Count of Positive Values in a Row - with Gaps

    Hi all If I want to find the average of the count totals of consecutive positive values in a row, with gaps of zeros, what formula could I use? An example would be: 1 1 1 1 2 2 2 3 1 1 0 0 0 0 0 0 0 1 2 5 3 3 2 There are two consecutive rows of positive values within the row. The first is...
  14. B

    Count consecutive occurrences when sum of two consecutive numbers below 3

    Hello, I have a column of numbers : 3 0 4 2 1 0 5 0 3 2 0 2 I am trying to get the number of times the sum of two consecutive rows is below 3. In this example 4 (i.e. 2+1,1+0,2+0 and 0+2). I tried a way around with this formula : =SUMPRODUCT(--(FREQUENCY(IF(C5:C16<2, ROW(C5:C16))...
  15. K

    Conditional formatting consecutive duplicate and triplicate values

    Hello, I'm hoping someone can help me figure out a formula. I am trying to conditionally format when the value of "1" shows up consecutively twice with one color and conditionally format it if it shows up 3 consecutive times with a different color. Here's my example: C4 = 1 C5 = 1 C6 = 0 C7...
  16. G

    2 Consecutive Cells match (Column A&B) match 2 other Consecutive cells (Column D&E), copy entry in Column C to Column F

    Hi Everyone, First time posting so hopefully this is clear. I need a formula that can help find and populate an entry when 2 consecutive cells in the same row match 2 other consecutive cells in other columns. i.e. Cell A2 = John Cell B2 = Smith Cell C2 = Blue Cell D13 = John Cell E13 =...
  17. D

    Count Consecutive Dates

    So I have a list of products that may show up on a report for consecutive dates. I'd like to count the current consecutive Workdays (Monday -Friday) the product has been on the list and reset the counter once it disappears for 1 day. Thank you in advance. Dean <colgroup><col style="width...
  18. R

    macro or other ways to arrange columns so that there will be no consecutive duplicates

    Hi Everyone, I have a table of two columns, one column for dates and the other column with duplicates items. I was wondering if there is a macro to arrange the 1st column by dates, and the second column with no consecutive duplicates (i.e. as much as possible as sometimes there is no way to...
  19. C

    LARGE formula that finds consecutive numbers

    Is there a way to utilize the LARGE formula, but have it pick the highest consecutive periods? I am looking at a very wide set of data, 20 years by quarter, and need to find the peak volume for any four-month (consecutive) span. The LARGE function is only finding the biggest four months...
  20. Z

    Two consecutive consonants in a name and surname

    What formula can I use to identify two consecutive consonants in the name and surname columns.eg name Ndoluvo and surname Khaye formula should identify any two consecutive consonants the name and surname starts with

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