For Pick 3
Place each drawn digit in Cells A1 to C1
Excel Formula
=IF(COUNTIF(A1:C1,0)=0,0,"")&IF(COUNTIF(A1:C1,1)=0,1,"")&IF(COUNTIF(A1:C1,2)=0,2,"")&IF(COUNTIF(A1:C1,3)=0,3,"")&IF(COUNTIF(A1:C1,4)=0,4,"")&IF(COUNTIF(A1:C1,5)=0,5,"")&IF(COUNTIF(A1:C1,6)=0,6,"")&IF(COUNTIF(A1:C1,7)=0,7,"")&IF(COUNTIF(A1:C1,8)=0,8,"")&IF(COUNTIF(A1:C1,9)=0,9,"")
For Pick 4 use 4 columns and change the range in the equation to "A1
1"
Hope this helps