Missing Digits.

[serge]

I'm looking for a formula starting in K7 that will return the missing digits.The total digits are 0,1,2,3 that’s all and in row F7:H7 are my initial digits.
Thank you


<a href="http://tinypic.com?ref=2uegrx1" target="_blank"><img src="http://i64.tinypic.com/2uegrx1.png" border="0" alt="Image and video hosting by TinyPic"></a>

 

[Rick Rothstein]

Put this formula in cell K7 and copy it across to cell M7, then copy the range K7:M7 down to the bottom of your data...

[table="width: 500"]
[tr]
	[td]=MID(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE("0123",$F7,""),$G7,""),$H7,""),COLUMNS($K:K),1)[/td]
[/tr]
[/table]

 

[dave2018]

I'm looking for a formula starting in K7 that will return the missing digits.The total digits are 0,1,2,3 that’s all and in row F7:H7 are my initial digits.
Thank you

hi, just wondering how to embed images in posts?

thx

 

[serge]

Thank you Rick, your formula work very well.
Serge.

 

[serge]

Dave,

I use " http://tinypic.com/ website to record my picture, and use the website link they give you, copy paste into Mr Excel and that's it.
Serge.

 

[dave2018]

Dave,

I use " http://tinypic.com/ website to record my picture, and use the website link they give you, copy paste into Mr Excel and that's it.
Serge.

thx! i will give it a try.