Using modulo function on pick3 game would be mod(10) since there are 10 numbers. On your data manipulation any result that is greater than 9 will wrap around. For example: pick3 lotto math for addition 6+7=3. To do this in excel using modulo function would be =mod((6+7),10)

The same concept can be applied to any lotto game. Another example using pick5 from a poll of 36 numbers would be =mod((x+y),36). Thus if x+y>36 ,the result will wrap around.