I need something simple

%3CLINGO-SUB%20id%3D%22lingo-sub-2058288%22%20slang%3D%22es-ES%22%3EI%20need%20something%20simple%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2058288%22%20slang%3D%22es-ES%22%3EHello%20excel%2C%20how%20can%20I%20make%20a%20function%20to%20count%20the%20maximum%20consecutive%20of%20a%20list%20of%20values%3F%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2058288%22%20slang%3D%22es-ES%22%3E%3CLINGO-LABEL%3EFormulas%20and%20functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2058324%22%20slang%3D%22en-US%22%3ERe%3A%20I%20need%20something%20simple%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2058324%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F928209%22%20target%3D%22_blank%22%3E%40Claubillo%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIt%20may%20be%20in%20the%20translation%2C%20but%20it's%20not%20clear%20what%20you%20mean%20by%20%22maximum%20consecutive%22%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECould%20you%20give%20an%20example%20of%20what%20the%20series%20of%20values%20might%20look%20like%2C%20and%20then%20what%20you%20mean%20by%20that%20calculated%20%22maximum%20consecutive%22%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor
Hello excel, how can I make a function to count the maximum consecutive of a list of values?
1 Reply

@Claubillo 

 

It may be in the translation, but it's not clear what you mean by "maximum consecutive"

 

Could you give an example of what the series of values might look like, and then what you mean by that calculated "maximum consecutive"?