Missing Digits

[bloubul]

Hi All

I'm looking for a formula to show all digits that has been left out of a draw.

Here is an example of my file.

https://www.mediafire.com/?48xlqrd2dj2eyad

I thank you.

BlouBul

 

[AllenB]

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 "A11"
Hope this helps

 

[AllenB]

I tried to get rid of that stinking Icon but could not. the Range for Pick 4 would be A1<:>D1 without the <>

 

[Icewynd]

And here we thought you were trying to be cute!

 

[bloubul]

AllenB

Thanks for the formula but excel complains and gives me #NAME

BlouBul

 

[AllenB]

I pasted directly from excel where the formula worked fine.
If you changed anything make sure the data ranges are correct and that "countif" is spelled right every place.