excelNewbie22
Well-known Member
- Joined
- Aug 4, 2021
- Messages
- 510
- Office Version
- 365
- Platform
- Windows
hi!
how to check sequence in a range c2:h2 ?
i want to check if there's sequence of 4 numbers out of 6, (2-3-4-5-11-20)
and two pairs of sequences out of 6 (11-12-13-20-21-22)
and three sequences pairs of two's (1-2-6-7-22-23)
tried several ways (with one formula with no luck)
if needed for each one different formula, also good
thank you!!
how to check sequence in a range c2:h2 ?
i want to check if there's sequence of 4 numbers out of 6, (2-3-4-5-11-20)
and two pairs of sequences out of 6 (11-12-13-20-21-22)
and three sequences pairs of two's (1-2-6-7-22-23)
tried several ways (with one formula with no luck)
if needed for each one different formula, also good
thank you!!