|Posted: November 28, 2010, 6:37 am - IP Logged|
First question :
I have in cell A1 through A5 the following digits 3,5,2,9,8.
and I need formulas in A7 through A11 to give me the missing digits which would be for this example :
Second Question :
Same thing but, can this be done also for more numbers from 1 to 56 ?
For example I have in A1 through A5 the following numbers : 2,12,34,44,53.
so the missing numbers would be all the numbers from 1 to 56 minius : 2,12,34,44,53.
I hope someone can help ? Thank you all.