1. R

    Finding consecutive date pattern

    Hi I require a formula that checks dates shown on a row and sees if they are consecutive days, and return the quantity of consecutive days. If possible it also needs to discard weekend days, therefore Thursday 1st, Friday 2nd and Monday 5th will count as 3 consecutive days. Finally, each row...
  2. V

    Looking Up consecutive values/text

    Hello everyone. I'm new here and excited to share and answer. I've ran into several situations were I need to compare a list of values/text to see if they consecutively match up in a separate table/range. I thing I have finally found a solution which can be universally applied in similar...
  3. A

    Removing consecutive number sets

    From a list of 6 digit number sets, is there a way to remove all sets that have a 4 or more digit consecutive sequence in it?
  4. K

    Air Quality - Want to know if consecutive value is above certain threshold for 24 hours

    Dear all, I need some help with figuring out my Air Quality Data. I have a device measuring PM2,5 every 5 minutes. To know whether the air quality meets criteria set by the WHO, I need to know if my measurements keep above 15 ug/m3 for 24 hours continuously. For this I need to know whether my...
  5. G

    Loop Calculate and paste results in consecutive rows

    Hi Folks, I have been using a loop to calculate the results of a formula and past those results into consecutive rows in the same sheet. Things generally work fine, but at a point something isn't quite working and I get SPILL issues and some charts lose their data as cells move...even though...
  6. S

    Find more than one maximum value before a zero

    Hello everyone I'm trying to use the formula =MAX(FREQUENCY(IF(T2:T11>1,COLUMN(T2:T11)),IF(T2:T11>=1,COLUMN(T2:T11)))) to find more than one maximum value before a zero from a range. Column T has this values 1 2 0 1 2 3 4 5 6 0 I want a formula/formulas that will...
  7. O

    Highlight rows if values in a column are consecutive

    Hello, I'm trying to highlight all rows based on whether values in a certain column are consecutive numbers. My spreadsheet is thousands of rows long and each cell in column I contains an 11-digit number. If any of those numbers are consecutive, I would like the whole row highlighted. I tried...
  8. 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...
  9. 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...
  10. 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))...
  11. 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
  12. 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...
  13. D


    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
  14. 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...
  15. 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...
  16. 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...
  17. L

    Remove consecutive numbers

    Hello Guys, I saw this post here: 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...
  18. 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...
  19. 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...
  20. 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...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back