EXCEL-Numbers in Sequence
Hi,
Someone whou knows how to count the maximum amount of numbers that are in
consecutive sequence regardless of their position out of a selected numbers
of cells.
I have 7 cells which each can contain a number from 1-15.
E.g.: 1 4 3 10 8 5 11
Above the max is 3 numbers who are in consecutive sequence i.e. 3 4 5.
If someone knows how to make a formula to count this would be great.
The Gasell
|