Excel help needed ( Missing digits )

Reply #4

frenchie — Wed, 08 Dec 2010 10:50:46 GMT

Hi Winsumloosesum,

Sincere apologies for my late reply...but I want to thank you for your prompt response, that was exactly what I needed. Regards...Frenchie

Reply #3

winsumloosesum — Sun, 05 Dec 2010 00:23:16 GMT

Frenchie,

I posted your question at mrexcel.com and here is the download link:

http://www.box.net/shared/agjglhnvig

Reply #2

frenchie — Sat, 04 Dec 2010 23:33:45 GMT

Hello time*treat,

Yes, I need it in formula, ( No Macro ) because I would like to use it for other charts, and it actualy be better in row than column, so it would be from : A1 to E1 and the missing digits from : G1 to K1, and I will drag it down for the rest of my chart.

Thank you.

Reply #1

time*treat — Sat, 04 Dec 2010 18:31:55 GMT

Does it have to be a cell formula

Excel help needed ( Missing digits )

frenchie — Sun, 28 Nov 2010 11:37:16 GMT

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... [ More ]