chriscorpion786
Board Regular
- Joined
- Apr 3, 2011
- Messages
- 108
- Office Version
- 365
- Platform
- Windows
Hi All,
I need a formula to count the sequence of numbers from Product A to Product G, I have done it manually, but if I have thousands of rows, i need a formula to do this.
I need a formula to count the sequence of numbers from Product A to Product G, I have done it manually, but if I have thousands of rows, i need a formula to do this.
Product A | Product B | Product C | Product D | Product E | Product F | product G | Serial number sequence (Counted Max one) |
125,666 | 125,667 | 15 | 556 | 557 | 558 | 559 | 4 |
450 | 666 | 667 | 668 | 669 | 670 | 888 | 5 |
333 | 566 | 475 | 123 | 987 | 100 | 9 | 0 |
100 | 101 | 102 | 103 | 104 | 105 | 106 | 7 |
98 | 99 | 100 | 99 | 98 | 31 | 32 | 3 |
56 | 57 | 88 | 87 | 10 | 11 | 12 | 3 |