Notifications
Clear all
General Excel Questions & Answers
4
Posts
3
Users
0
Reactions
74
Views
Topic starter
I have to find the value in the cell in the next cell which value is in sequence.
I have used ISNUMBER formula, its finding only if the value exist, its not listing the sequence.
Please refer the below list
| S No | Value | Sequence | Isnumber find formula |
| 1 | 1 | 1-2, 3, 4-10 | TRUE |
| 2 | 2 | 1-2, 3, 4-10 | TRUE |
| 3 | 3 | 1-2, 3, 4-10 | TRUE |
| 4 | 4 | 1-2, 3, 4-10 | TRUE |
| 5 | 5 | 1-2, 3, 4-10 | FALSE |
| 6 | 6 | 1-2, 3, 4-10 | FALSE |
| 7 | 7 | 1-2, 3, 4-10 | FALSE |
| 8 | 8 | 1-2, 3, 4-10 | FALSE |
| 9 | 9 | 1-2, 3, 4-10 | FALSE |
| 10 | 10 | 1-2, 3, 4-10 | TRUE |
Any formula is there to find out the value in that sequence?.
Posted : 05/12/2017 6:53 am
Hi,
Please test attached file, hope it helps. Please note that these are array formulas.
Clark
Posted : 06/12/2017 11:55 pm
Interesting! Can you explain how this works? (I see it does....)
Posted : 07/12/2017 10:40 am
there are more solutions for you reference.
Posted : 07/12/2017 9:11 pm
