Peter Selwin
New Member
- Joined
- Apr 23, 2018
- Messages
- 4
Hello guys,
Can anyone think of a way to add a value to every Nth cell that has a repeating value?
Example:
<tbody></tbody>
<colgroup><col style="width:48pt" width="64"> </colgroup><tbody>
</tbody>
Every 5th value in the column that has the same value would be renamed with a number when a macro is used:
<tbody>
<colgroup><col style="width:48pt" width="64"> </colgroup><tbody>
</tbody>
</tbody>
I'm puzzled on this one!
Thanks!
Can anyone think of a way to add a value to every Nth cell that has a repeating value?
Example:
<tbody></tbody>
Bob |
Bob |
Bob |
Bob |
Bob |
Bob |
Bob |
Bob |
Bob |
Bob |
Bob |
Bob |
Bob |
Tony |
Tony |
Tony |
Tony |
Tony |
Tony |
Tony |
Tony |
Tony |
Tony |
Tony |
Tony |
Sue |
Sue |
Sue |
Sue |
Sue |
Sue |
<colgroup><col style="width:48pt" width="64"> </colgroup><tbody>
</tbody>
Every 5th value in the column that has the same value would be renamed with a number when a macro is used:
<tbody>
Bob |
Bob |
Bob |
Bob |
Bob |
Bob - 2 |
Bob - 2 |
Bob - 2 |
Bob - 2 |
Bob - 2 |
Bob - 3 |
Bob - 3 |
Bob - 3 |
Tony |
Tony |
Tony |
Tony |
Tony |
Tony - 2 |
Tony - 2 |
Tony - 2 |
Tony - 2 |
Tony - 2 |
Tony - 3 |
Tony - 3 |
Sue |
Sue |
Sue |
Sue |
Sue |
Sue - 2 |
<colgroup><col style="width:48pt" width="64"> </colgroup><tbody>
</tbody>
I'm puzzled on this one!
Thanks!