# consecutive

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

### 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 MrExcel.com.

### Which adblocker are you using?

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

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
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