How to check if there are at least 5 contiguous cells over 125

Hi dear readers. Today we want to talk about one of Microsoft Excel’s features. This Excel feature is probably important to you and you will be using some of the projects you are currently in. You may have entered a column of numbers in Excel. These numbers can be related to the price of your company’s products, or whether it relates to the grades of one lesson or anything else. They are displayed with the numbers. You need to use formulation if you need to find 5 consecutive cells that have a higher number than the number you mention. You will find out in this tutorial that how to check if there are at least 5 contiguous cells over 125.

A Simple Solution

An easy way to solve this problem is to use the formula {=If( , , )}. Follow below steps.

Step1: Open Microsoft Excel and insert your data. You can add sample data to learn How to check if there are at least 5 contiguous cells over 125. Write =RANDBETWEEN(,) in cell A2. You should write two numbers in Parentheses. The first number is the smallest value, and the second number is the highest you want to enter. These numbers are the total length of your data.

I chose the numbers 60 as the lowest and 400 as the largest amount for the data range.

How to check if there are at least 5 contiguous cells over 125

Press enter and then drag the small square to cell A100 or every cell you want.

How to check if there are at least 5 contiguous cells over 125

How to check if there are at least 5 contiguous cells over 125

Step2: Put value 0 in cell B1 and write below formula in cell B2 then press enter.

=If(A2>125,B1+1,0)

How to check if there are at least 5 contiguous cells over 125

Step3: Drag the small square to cell B100.

How to check if there are at least 5 contiguous cells over 125

As you see in each cell, the column A, which is more than 125, gives a value of 1 in the side column. If the next cell in column A is again more than 125, then a number is added to the previous number in the side column and put it in the next cell. This process continues. If the next number in column A is less than 125, then the value will be 0 in the side column.

How to check if there are at least 5 contiguous cells over 125

Great! You learned How to check if there are at least 5 contiguous cells over 125.

How to check if there are at least 5 contiguous cells over 125
4.2 (83%) 20 votes

0 replies

Leave a Reply

Want to join the discussion?
Feel free to contribute!

Leave a Reply

Your email address will not be published. Required fields are marked *