Welcome Guest
You last visited April 25, 2017, 6:30 am
All times shown are
Eastern Time (GMT-5:00)

Excel help needed ( Missing digits )

Topic closed. 4 replies. Last post 6 years ago by frenchie.

 Page 1 of 1
Los Angeles
United States
Member #75410
June 2, 2009
502 Posts
Offline
 Posted: November 28, 2010, 6:37 am - IP Logged

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 someone can help ?             Thank you all.

United States
Member #13130
March 30, 2005
2171 Posts
Offline
 Posted: December 4, 2010, 1:31 pm - IP Logged

Does it have to be a cell formula?

In neo-conned Amerika, bank robs you.
Alcohol, Tobacco, and Firearms should be the name of a convenience store, not a govnoment agency.

Los Angeles
United States
Member #75410
June 2, 2009
502 Posts
Offline
 Posted: December 4, 2010, 6:33 pm - IP Logged

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.

Pennsylvania
United States
Member #2218
September 1, 2003
5454 Posts
Offline
 Posted: December 4, 2010, 7:23 pm - IP Logged

Frenchie,

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

Los Angeles
United States
Member #75410
June 2, 2009
502 Posts
Offline
 Posted: December 8, 2010, 5:50 am - IP Logged

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

 Page 1 of 1