Excel group data

%3CLINGO-SUB%20id%3D%22lingo-sub-1919612%22%20slang%3D%22en-US%22%3EExcel%20group%20data%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1919612%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20I%20have%20a%20great%20amount%20of%20data%20that%20ramp%20up%20from%200%20to%202000%20and%20goes%20back%20to%200%20but%20occasionally%20it%20would%20only%20goes%20up%20to%20200%20and%20then%20go%20back%20to%200.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20wonder%20what%20function%20should%20I%20use%20to%20find%20how%20many%20times%20it%20only%20goes%20up%20to%20200%20instead%20of%202000%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20advise%3F%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1919612%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1920246%22%20slang%3D%22de-DE%22%3ESubject%3A%20Excel%20group%20data%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1920246%22%20slang%3D%22de-DE%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F876754%22%20target%3D%22_blank%22%3E%40RZ_CK1996%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3E%3CSPAN%3EWith%20your%20permission%2C%20insert%20a%20file%20(without%20sensitive%20data)%20and%20explain%20your%20plan%20on%20the%20basis%20of%20this%20file.%3C%2FSPAN%3E%3C%2FSPAN%3E%20%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3E%3CSPAN%3ESo%20you%20can%20hope%20for%20a%20faster%20and%20more%20precise%20answer.%3C%2FSPAN%3E%3C%2FSPAN%3E%20%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3E%3CSPAN%3EA%20detailed%20description%20of%20your%20Excel%20version%20and%20operating%20system%20would%20be%20beneficial%20for%20everyone.%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3E%3CSPAN%3EThank%20you%20for%20your%20patience%20and%20time%3C%2FSPAN%3E%3C%2FSPAN%3E%20%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3E%3CSPAN%3ENikolino%3C%2FSPAN%3E%3C%2FSPAN%3E%20%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3E%3CSPAN%3EI%20know%20that%20I%20know%20nothing%20(Socrates)%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
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

@RZ_CK1996 

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

 

Nikolino

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

 

=SUBTOTAL(3,A2:A200)

Or

=COUNTA(A2:A200)