Search

Excel help needed ( Missing digits )
Hi Everyone, 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 : 0,1,4,6,7. 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 so
Nov 28, 2010, 6:37 am - frenchie - Mathematics Forum