Cubist
Well-known Member
- Joined
- Oct 5, 2023
- Messages
- 811
- Office Version
- 365
- Platform
- Windows
- MacOS
Book3 | |||||||||
---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | |||
1 | 1 | 2 | 1 | 6 | 6 | 1 | 1 | ||
2 | |||||||||
3 | Expected | FALSE | FALSE | FALSE | TRUE | FALSE | TRUE | ||
4 | Formula | FALSE | FALSE | FALSE | FALSE | FALSE | FALSE | ||
Sheet4 |
Cell Formulas | ||
---|---|---|
Range | Formula | |
B4:G4 | B4 | =SCAN(A1,B1:G1,LAMBDA(a,b,a=b)) |
Dynamic array formulas. |
I'm attempting to use SCAN() to check if consecutive cells are equal but it's not giving the expected result. Perhaps I'm misusing the function. Any thoughts?