CONFUSED_AS_USUAL
Board Regular
- Joined
- Jul 6, 2017
- Messages
- 59
Hi,
Column B starts with 1 & increases by 1 everytime it encounters the same # in Column A.
For illustration purposes, Column C has been manually populated & has returned the highest (last number). This is what I am looking for.
What formula or macro can be made & used to perform this ? I have thousands of lines.
Thks
<colgroup><col width="64" span="2" style="width:48pt"> <col width="64" style="width:48pt"> </colgroup><tbody>
</tbody>
Column B starts with 1 & increases by 1 everytime it encounters the same # in Column A.
For illustration purposes, Column C has been manually populated & has returned the highest (last number). This is what I am looking for.
What formula or macro can be made & used to perform this ? I have thousands of lines.
Thks
A | B | C |
1 | 1 | 4 |
1 | 2 | 4 |
1 | 3 | 4 |
1 | 4 | 4 |
2 | 1 | 2 |
2 | 2 | 2 |
3 | 1 | 6 |
3 | 2 | 6 |
3 | 3 | 6 |
3 | 4 | 6 |
3 | 5 | 6 |
3 | 6 | 6 |
<colgroup><col width="64" span="2" style="width:48pt"> <col width="64" style="width:48pt"> </colgroup><tbody>
</tbody>