| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can excel find a sequence of numbers from a known total? | Excel Discussion (Misc queries) | |||
| Can excel find a sequence of numbers from a known total? | Excel Worksheet Functions | |||
| How do I use excel to add up the best 5 numbers in a sequence? | New Users to Excel | |||
| sequence numbers | Excel Discussion (Misc queries) | |||
| how do I sequence numbers | Excel Discussion (Misc queries) | |||
Threaded Mode
