consecutive cell

  1. Y

    Max frequency for consecutive text multiple condition

    Hi I need the formula for max frequency or similar to this, Problem statement is - I have an attendance record of 1 month in which I need to calculate a repeated occurrence. let's say.. if Mr. ABC is present (P) from 1-April to 7 April, and then on his Week off day he was present then the...
  2. N

    Count max no of consecutive positive/negative value in a filtered column

    Hello all, Excited for my first post. MrExcel has been extremely useful in my excel journey, even as a non member, and I couldn't be more thankful ? My question: I have a column with positive and negative values in sheet "Sheet1" (image below). I would like to count the max number of...
  3. C

    countif # two consective cells have zeros

    I have data in excel like this <tbody> A B C D E F G H I J K L M N 0 0 0 0 22 55 7 3 0 0 0 5 44 5 </tbody> I want to countif consecutive two cells have "SAY value" 0 So first 4 columns will return frequency function =2 if all columns given as cell range for...

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