Excel group data

Occasional Visitor

Hi I have a great amount of data that ramp up from 0 to 2000 and goes back to 0 but occasionally it would only goes up to 200 and then go back to 0.


I wonder what function should I use to find how many times it only goes up to 200 instead of 2000?


Any advise? 

2 Replies


With your permission, insert a file (without sensitive data) and explain your plan on the basis of this file. So you can hope for a faster and more precise answer.


A detailed description of your Excel version and operating system would be beneficial for everyone.


Thank you for your patience and time



I know that I know nothing (Socrates)

@RZ_CK1996 ,,


Seems that you are either Filtering the data or using Sort & Group in  both cases you may use formula to count not blank or visible cells, will return total rows appears. 


You may use,,