muhammad susanto
Well-known Member
- Joined
- Jan 8, 2013
- Messages
- 2,077
- Office Version
- 365
- 2021
- Platform
- Windows
hi all...
how to get the row number depend on data adjacent.
the row always minus 1 row
like that below :
Excel 2007
<tbody>
</tbody>
any help, much appreciated...
m.susanto
how to get the row number depend on data adjacent.
the row always minus 1 row
like that below :
Excel 2007
row | A | B |
---|---|---|
1 | data | expected result after formula |
2 | 5 | 1 |
3 | 0 | 5 |
4 | 0 | 6 |
5 | 0 | 12 |
6 | 12 | |
7 | 10 | |
8 | 0 | |
9 | 0 | |
10 | 0 | |
11 | 0 | |
12 | 0 | |
13 | 24 |
<tbody>
</tbody>
any help, much appreciated...
m.susanto
Last edited: