consecutive

I have a rainfall table and the google sheet link is provided below. For each year, I want to count number of days, fulfilling following both two conditions: 1) Number of days where rainfall is more than or equal to 1 mm. 2) Count only those days which are not single. In other words, I want to...

I have a report that shows how many views datasets have each week. For each row I wish to calculate 2 values: - Total Zero = The number of weeks with zero views after the data has been viewed in a prior week - Consecutive Zero = The number of consecutive weeks with zero views, where the most...

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

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

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?

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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