Welcome Guest
Log In | Register )
You last visited December 6, 2016, 4:45 am
All times shown are
Eastern Time (GMT-5:00)

Need formula to create pairs from a string number row.

Topic closed. 5 replies. Last post 5 years ago by frenchie.

Page 1 of 1
PrintE-mailLink
frenchie's avatar - Lottery-041.jpg
Los Angeles
United States
Member #75410
June 2, 2009
479 Posts
Offline
Posted: December 20, 2011, 3:16 pm - IP Logged

Hello everyone,

I'm looking for a formula that will create pairs from a row.

Thank you for any help.

Serge.

    RJOh's avatar - chipmunk
    mid-Ohio
    United States
    Member #9
    March 24, 2001
    19825 Posts
    Offline
    Posted: December 20, 2011, 3:25 pm - IP Logged

    Seems like that formula have a lot of variables repeat, you probably can remove some of them and forget about that background-color, if the formula works it doesn't have to look pretty too.

     * you don't need to buy more tickets, just buy a winning ticket * 
       
                 Evil Looking       

      frenchie's avatar - Lottery-041.jpg
      Los Angeles
      United States
      Member #75410
      June 2, 2009
      479 Posts
      Offline
      Posted: December 20, 2011, 3:31 pm - IP Logged

      How can I post a piece of my spreadsheet to show the display ?

        frenchie's avatar - Lottery-041.jpg
        Los Angeles
        United States
        Member #75410
        June 2, 2009
        479 Posts
        Offline
        Posted: December 22, 2011, 12:33 am - IP Logged

        Here is the simple file.

        http://cjoint.com/?0LwgGq3r6Ul

        Thank you.

        Serge.

          winsumloosesum's avatar - Lottery-060.jpg
          Pennsylvania
          United States
          Member #2218
          September 1, 2003
          5387 Posts
          Offline
          Posted: December 23, 2011, 8:37 am - IP Logged

          Not sure if this is what you wanted frenchie

          http://www.box.com/s/4xs9hpovuhzy2z20h80x

            frenchie's avatar - Lottery-041.jpg
            Los Angeles
            United States
            Member #75410
            June 2, 2009
            479 Posts
            Offline
            Posted: December 23, 2011, 5:06 pm - IP Logged

            Hello Winsum,

            Thank you for the reply, it is close to what I need and your formulas works fine , thank you.

            What I'm looking for is one formula that I would put in cell R10 and just drag to the right, up to AZ10 and would eather return all pairs if all the 9 digits are there or return blanc cells if there is less digits  to deal with.

            And the same for the duplicate one.

             

            I know it's possible but I'm not qualify for such formula !!!.

            Thank you.

            Serge.