muhammad susanto
Well-known Member
- Joined
- Jan 8, 2013
- Messages
- 2,077
- Office Version
- 365
- 2021
- Platform
- Windows
hi all..
i have a list.. but into list contains "jumping" number / not series..
how to determine , count of number not series / not sequence
the answer is 6, how to determine it?
6 from (4,6,7,12.15.16 as jumping number)
please, don't use helper column
thank in advance
susanto
i have a list.. but into list contains "jumping" number / not series..
how to determine , count of number not series / not sequence
date Query function with date filter.xlsx | |||
---|---|---|---|
G | |||
2 | sequences list | ||
3 | 1 | ||
4 | 2 | ||
5 | 3 | ||
6 | 5 | ||
7 | 8 | ||
8 | 9 | ||
9 | 10 | ||
10 | 11 | ||
11 | 13 | ||
12 | 14 | ||
13 | 17 | ||
Sheet1 |
the answer is 6, how to determine it?
6 from (4,6,7,12.15.16 as jumping number)
please, don't use helper column
thank in advance
susanto