Welcome Guest
Log In | Register )
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
PrintE-mailLink
frenchie's avatar - Lottery-041.jpg
Thread Starter
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.

    time*treat's avatar - radar

    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.

      frenchie's avatar - Lottery-041.jpg
      Thread Starter
      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.

        winsumloosesum's avatar - Lottery-060.jpg
        Pennsylvania
        United States
        Member #2218
        September 1, 2003
        5454 Posts
        Offline
        Posted: December 4, 2010, 7:23 pm - IP Logged

        Frenchie,

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

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

          frenchie's avatar - Lottery-041.jpg
          Thread Starter
          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