Well you didn't exactly answer either of my questions, I already knew what the output format would be, just what your definition of a pair in the USA pick three was would have helped. So Ive had to do what I think you might want. Heres how I would do it without resorting to macros. Note that the three digit result has to be formatted to show all three digits, even when it starts with an "0". I've added a triple counter or result counter as I see it on another sheet. Note my test results are all random numbers.
As you know, I dont do wheels.
http://www.mediafire.com/file/m7zscix13wt8054/pick_3_paircounter.xlsx/file