yamapinews
New Member
- Joined
- Nov 28, 2016
- Messages
- 9
Column A are number arranged in sequence, I need a formula than can be rolled down to show a sub-sequence like below
<colgroup><col width="74" style="width:56pt"> <col width="72" style="width:54pt"> </colgroup><tbody>
</tbody>
| ColA | ColB |
| 1 | 1.1 |
| 1 | 1.2 |
| 2 | 2.1 |
| 3 | 3.1 |
| 3 | 3.2 |
| 3 | 3.3 |
| 4 | 4.1 |
| 5 | 5.1 |
| 6 | 6.1 |
| 7 | 7.1 |
| 7 | 7.2 |
<colgroup><col width="74" style="width:56pt"> <col width="72" style="width:54pt"> </colgroup><tbody>
</tbody>
Last edited:
