SR# (Column A ) | J# FROM (Column B) | J# TO (Column C) |
1 | 96604 | 96606 |
2 | 96560 | 96586 |
3 | 96555 | 96559 |
4 | 96538 | 96539 |
5 | 96540 | 96542 |
6 | 96530 | 96537 |
7 | 96375 | 96384 |
8 | 96385 | 96427 |
9 | 96428 | 96457 |
10 | 96458 | 96465 |
11 | 96497 | 96521 |
12 | 96525 | 96527 |
13 | 96529 | |
14 | 96545 | 96551 |
15 | 96466 | 96490 |
Hello,
Need formula to show result from SR#.
eg:-
if i enter 96605 than result should be showing 1
if i enter 96560 than result should be showing 2
Thanks in Advance
Last edited: