Welcome Guest
Log In | Register )
You last visited December 3, 2016, 10:50 pm
All times shown are
Eastern Time (GMT-5:00)

Excel Question

Topic closed. 7 replies. Last post 8 years ago by Rakster.

Page 1 of 1
PrintE-mailLink
Rakster's avatar - praying hands.jpg
Saskatchewan
Canada
Member #19992
August 9, 2005
2867 Posts
Offline
Posted: April 11, 2009, 1:55 am - IP Logged

Does anyone know a formula or set of formula's for ordering a row of numbers from highest to lowest?

Example...

1001
2110
3111
4112
5100
6110
7100
8030
9102
0001

Now I want add another row with these formula's to place the most frequent # first and then rotate down to the fewest called.

HITS
D1D2D3ALL
10011A4
21102B9
31113C8
41124D3
51001E2
61102F6
71001G1
80303H0
91023I5
00011J7

Is there a formula that can be implimented here? Thanks

We are all Lucky... just some of us don't realize it!

    time*treat's avatar - radar

    United States
    Member #13130
    March 30, 2005
    2171 Posts
    Offline
    Posted: April 11, 2009, 2:46 am - IP Logged

    www.lotterypost.com/thread/124458/499321 might help. Wink

    but you gotta tell us if you're looking for macros or formulas.

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

      Rakster's avatar - praying hands.jpg
      Saskatchewan
      Canada
      Member #19992
      August 9, 2005
      2867 Posts
      Offline
      Posted: April 11, 2009, 8:35 am - IP Logged

      www.lotterypost.com/thread/124458/499321 might help. Wink

      but you gotta tell us if you're looking for macros or formulas.

      I'm not sure what a macro is...lol... so I would guess formula?

      I want to just order my numbers from most represented to lowest represented.... I'll check that link... thanks

      We are all Lucky... just some of us don't realize it!

        Rakster's avatar - praying hands.jpg
        Saskatchewan
        Canada
        Member #19992
        August 9, 2005
        2867 Posts
        Offline
        Posted: April 11, 2009, 9:54 am - IP Logged

        Does anyone know a formula or set of formula's for ordering a row of numbers from highest to lowest?

        Example...

        1001
        2110
        3111
        4112
        5100
        6110
        7100
        8030
        9102
        0001

        Now I want add another row with these formula's to place the most frequent # first and then rotate down to the fewest called.

        HITS
        D1D2D3ALL
        10011A4
        21102B9
        31113C8
        41124D3
        51001E2
        61102F6
        71001G1
        80303H0
        91023I5
        00011J7

        Is there a formula that can be implimented here? Thanks

        This is going to be tough formulating this...

        I want the numbers in PURPLE to show up highest to lowest based on the numbers in YELLOW that represent them...

        Like the "4" had hit 4 times that week... need a formula that would indicate the "4" is the top number not the number of times it hit...

        Thats a bad example as the 4 hit 4 times... look at the 9... it hit 3 times.. I want the formula to show the 9 as second strongest as it hit 3 times... so the 9 appears not the 3...

        I know I am asking for a lot, but appreciate any help at all.

        Thanks

        We are all Lucky... just some of us don't realize it!

          CARBOB's avatar - FL LOTTERY_LOGO.png
          ORLANDO, FLORIDA
          United States
          Member #4924
          June 3, 2004
          5893 Posts
          Offline
          Posted: April 11, 2009, 10:39 am - IP Logged

          Rakster, is this what you are looking for? You  don't need a formula to sort. Put your cursor in the first cell of the first column, drag down and across to cover all the cells, then sort by the column where the hits are.

          HITS
          D1D2D3ALL
          41124A4
          31113B9
          80303C8
          91023D3
          21102E2
          61102F6
          10011G1
          51001H0
          71001I5
          00011J7
            Rakster's avatar - praying hands.jpg
            Saskatchewan
            Canada
            Member #19992
            August 9, 2005
            2867 Posts
            Offline
            Posted: April 11, 2009, 4:30 pm - IP Logged

            Rakster, is this what you are looking for? You  don't need a formula to sort. Put your cursor in the first cell of the first column, drag down and across to cover all the cells, then sort by the column where the hits are.

            HITS
            D1D2D3ALL
            41124A4
            31113B9
            80303C8
            91023D3
            21102E2
            61102F6
            10011G1
            51001H0
            71001I5
            00011J7

            Thanks CarBob!

            When I do this though, it turns all cells blue in color... but I can't sort.

            This way may not work either as all middle cells are formulated and I think it'll throw things out of whack.

            We are all Lucky... just some of us don't realize it!

              CARBOB's avatar - FL LOTTERY_LOGO.png
              ORLANDO, FLORIDA
              United States
              Member #4924
              June 3, 2004
              5893 Posts
              Offline
              Posted: April 11, 2009, 6:34 pm - IP Logged

              Thanks CarBob!

              When I do this though, it turns all cells blue in color... but I can't sort.

              This way may not work either as all middle cells are formulated and I think it'll throw things out of whack.

              The reason it turned your cells blue was because you started dragging in the column header instead of this,put your cursor in the first cell, keep the button down, when you get to the last cell, release the button. All the cells should be highlighted or flashing. Post a sample of your formulas. The formulas should still work. The references will change automatic.

                Rakster's avatar - praying hands.jpg
                Saskatchewan
                Canada
                Member #19992
                August 9, 2005
                2867 Posts
                Offline
                Posted: April 11, 2009, 7:51 pm - IP Logged

                The reason it turned your cells blue was because you started dragging in the column header instead of this,put your cursor in the first cell, keep the button down, when you get to the last cell, release the button. All the cells should be highlighted or flashing. Post a sample of your formulas. The formulas should still work. The references will change automatic.

                Thanks!

                We are all Lucky... just some of us don't realize it!