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

Can Excel do this?

Topic closed. 8 replies. Last post 10 years ago by sar30.

Page 1 of 1
PrintE-mailLink
Avatar

United States
Member #48158
December 12, 2006
32 Posts
Offline
Posted: April 2, 2007, 7:12 am - IP Logged

Is there a function in excel to create pairs of numbers out a 3 didgit number? Example: 312  pairs would  be 31,12 and  32.

 

also can excel determine repeating numbers? example

 

312/ 3

358/ 5,8

582/ 2

299 

 

If anyone knows the formula for excel to do this please share. Working on P3 sysytem. will share with  all if works. 

    Avatar
    Anywhere & Everywhere
    United States
    Member #10713
    January 23, 2005
    290 Posts
    Offline
    Posted: April 2, 2007, 2:21 pm - IP Logged

    Yes, excel can. is 312 in one cell or is each digit in individual cells?

      Avatar

      United States
      Member #48158
      December 12, 2006
      32 Posts
      Offline
      Posted: April 2, 2007, 2:33 pm - IP Logged

      312 would be one cell

        Raven62's avatar - binary
        New Jersey
        United States
        Member #17843
        June 28, 2005
        49725 Posts
        Offline
        Posted: April 2, 2007, 2:57 pm - IP Logged

        Their is no Function to create pairs, but you can create pairs by writing your own formulas. How much experience to you have using Excel?

        A mind once stretched by a new idea never returns to its original dimensions!

          hypersoniq's avatar - 8ball
          Pennsylvania
          United States
          Member #1340
          April 6, 2003
          2450 Posts
          Offline
          Posted: April 2, 2007, 8:54 pm - IP Logged

          let's say 312 is in cell A1

          to get the front pair(31) put this in cell B1

          =LEFT(A1,2)

          to get the back pair(12) put this in cell C1

          =RIGHT(A1,2)

          to get the bookends(32) put this in cell D1

          =CONCATENATE(LEFT(A1,1),RIGHT(A1,1))

          I'm not so sure about the repeating numbers from a single cell without a vba macro of some sort. I'll start working on that one...

          Playing more than one ticket per game is betting against yourself.

            Avatar

            United States
            Member #48158
            December 12, 2006
            32 Posts
            Offline
            Posted: April 2, 2007, 11:37 pm - IP Logged

            Thank you..

             

            I will try that...

              Avatar

              United States
              Member #48158
              December 12, 2006
              32 Posts
              Offline
              Posted: April 2, 2007, 11:47 pm - IP Logged

              Worked perfect

               

               

              Any way to count the number of the same pairs?

               

              or same numbers

                hypersoniq's avatar - 8ball
                Pennsylvania
                United States
                Member #1340
                April 6, 2003
                2450 Posts
                Offline
                Posted: April 3, 2007, 5:39 am - IP Logged

                to get a list count of all the pairs

                in column e1 thru e100 enter 00 thru 99

                (to get a leading zero, from the top menu go to format/cells/number/custom and enter 00)

                let's assume you have 9000 numbers

                in f1, enter

                =countif($B$1:$D$9000,E1)

                then drag it down to f100

                this will count ALL of the pairs without differentiation

                if you want to count all pairs and determine front pair/back pair/bookends...

                in f1 (for front pair)

                =countif($B$1:$B$9000,E1)

                in g1 (for back pair)

                =countif($C$1:$C$9000,E1)

                in h1 (for bookends)

                =countif($D$1:$D$9000,E1)

                drag(autofill) these down to f100, g100 and h100, respectively

                Playing more than one ticket per game is betting against yourself.

                  Avatar

                  United States
                  Member #48158
                  December 12, 2006
                  32 Posts
                  Offline
                  Posted: April 3, 2007, 7:23 am - IP Logged

                  I am not able to get this function to work: Here is my sample line starts at 2 and goes to 29 and want to count pairs in this range. 

                   

                   DE F
                  066202
                  711373
                  588252
                  522656
                  977898
                  888585
                  233121
                  022606
                  344030
                  855484
                  922292
                  388434
                  522757
                  644767
                  366838
                  477040
                  222828
                  155414
                  422040
                  055707
                  866585
                  244424
                  122717
                  266727
                  188616
                  022808
                  055505
                  122616