Excel Examples: Serial Numbers (Cricket Overs)
About the video
In this video tutorial we are going to discuss a few functions like ROWS, INT, and lots of complex formulas. The purpose is to create serial numbers like cricket overs. First, we make serial numbers by using the ROWS function, after that we divide the generated number with 6 to get numbers like balls of an over. Finally, we make separate integer and decimal parts to solve the problem. For better understanding, refer to the video.