unknownymous
Board Regular
- Joined
- Sep 19, 2017
- Messages
- 249
- Office Version
- 2016
- Platform
- Windows
Hi Guys,
I'm trying to create a macro where cell that has "0" value will be separated.
<tbody>
</tbody>
End result:
<tbody>
</tbody>
Any help will be much appreciated.
Thank you!
I'm trying to create a macro where cell that has "0" value will be separated.
Code | Name | Score 1 | Score 2 | Score 3 | Score 4 | Score 5 | Score 6 |
01 | John | 98 | 98 | 95 | 95 | 93 | 90 |
02 | Ben | 96 | 97 | 94 | 93 | 93 | 90 |
03 | Sean | 0 | 0 | 0 | 0 | 0 | 0 |
04 | Carl | 90 | 0 | 90 | 0 | 89 | 0 |
05 | Tim | 0 | 0 | 0 | 0 | 0 | 0 |
<tbody>
</tbody>
End result:
Code | Name | Score 1 | Score 2 | Score 3 | Score 4 | Score 5 | Score 6 |
01 | John | 98 | 98 | 95 | 95 | 93 | 90 |
02 | Ben | 96 | 97 | 94 | 93 | 93 | 90 |
04 | Carl | 90 | 0 | 90 | 0 | 89 | 0 |
03 | Sean | 0 | 0 | 0 | 0 | 0 | 0 |
05 | Tim | 0 | 0 | 0 | 0 | 0 | 0 |
<tbody>
</tbody>
Any help will be much appreciated.
Thank you!