All times shown are
Eastern Time (GMT-5:00) | Home -> Forums -> Mathematics -> Excel Question Saskatchewan Canada Member #20314 August 9, 2005 2615 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... | 1 | 0 | 0 | 1 | | 2 | 1 | 1 | 0 | | 3 | 1 | 1 | 1 | | 4 | 1 | 1 | 2 | | 5 | 1 | 0 | 0 | | 6 | 1 | 1 | 0 | | 7 | 1 | 0 | 0 | | 8 | 0 | 3 | 0 | | 9 | 1 | 0 | 2 | | 0 | 0 | 0 | 1 |
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 | | | | | | D1 | D2 | D3 | ALL | | | | 1 | 0 | 0 | 1 | 1 | A | 4 | | 2 | 1 | 1 | 0 | 2 | B | 9 | | 3 | 1 | 1 | 1 | 3 | C | 8 | | 4 | 1 | 1 | 2 | 4 | D | 3 | | 5 | 1 | 0 | 0 | 1 | E | 2 | | 6 | 1 | 1 | 0 | 2 | F | 6 | | 7 | 1 | 0 | 0 | 1 | G | 1 | | 8 | 0 | 3 | 0 | 3 | H | 0 | | 9 | 1 | 0 | 2 | 3 | I | 5 | | 0 | 0 | 0 | 1 | 1 | J | 7 |
Is there a formula that can be implimented here? Thanks We are all Lucky... just some of us don't realize it!
| | |
United States Member #13375 March 30, 2005 2113 Posts Offline | | Posted: April 11, 2009, 2:46 am - IP Logged | |
www.lotterypost.com/thread/124458/499321 might help.  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. | | |
Saskatchewan Canada Member #20314 August 9, 2005 2615 Posts Offline | | Posted: April 11, 2009, 8:35 am - IP Logged | |
www.lotterypost.com/thread/124458/499321 might help. 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!
| | |
Saskatchewan Canada Member #20314 August 9, 2005 2615 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... | 1 | 0 | 0 | 1 | | 2 | 1 | 1 | 0 | | 3 | 1 | 1 | 1 | | 4 | 1 | 1 | 2 | | 5 | 1 | 0 | 0 | | 6 | 1 | 1 | 0 | | 7 | 1 | 0 | 0 | | 8 | 0 | 3 | 0 | | 9 | 1 | 0 | 2 | | 0 | 0 | 0 | 1 |
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 | | | | | | D1 | D2 | D3 | ALL | | | | 1 | 0 | 0 | 1 | 1 | A | 4 | | 2 | 1 | 1 | 0 | 2 | B | 9 | | 3 | 1 | 1 | 1 | 3 | C | 8 | | 4 | 1 | 1 | 2 | 4 | D | 3 | | 5 | 1 | 0 | 0 | 1 | E | 2 | | 6 | 1 | 1 | 0 | 2 | F | 6 | | 7 | 1 | 0 | 0 | 1 | G | 1 | | 8 | 0 | 3 | 0 | 3 | H | 0 | | 9 | 1 | 0 | 2 | 3 | I | 5 | | 0 | 0 | 0 | 1 | 1 | J | 7 |
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!
| | |
ORLANDO, FLORIDA United States Member #5011 June 3, 2004 3293 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 | | D1 | D2 | D3 | ALL | | 4 | 1 | 1 | 2 | 4 | A | 4 | | 3 | 1 | 1 | 1 | 3 | B | 9 | | 8 | 0 | 3 | 0 | 3 | C | 8 | | 9 | 1 | 0 | 2 | 3 | D | 3 | | 2 | 1 | 1 | 0 | 2 | E | 2 | | 6 | 1 | 1 | 0 | 2 | F | 6 | | 1 | 0 | 0 | 1 | 1 | G | 1 | | 5 | 1 | 0 | 0 | 1 | H | 0 | | 7 | 1 | 0 | 0 | 1 | I | 5 | | 0 | 0 | 0 | 1 | 1 | J | 7 |
| | |
Saskatchewan Canada Member #20314 August 9, 2005 2615 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 | | D1 | D2 | D3 | ALL | | 4 | 1 | 1 | 2 | 4 | A | 4 | | 3 | 1 | 1 | 1 | 3 | B | 9 | | 8 | 0 | 3 | 0 | 3 | C | 8 | | 9 | 1 | 0 | 2 | 3 | D | 3 | | 2 | 1 | 1 | 0 | 2 | E | 2 | | 6 | 1 | 1 | 0 | 2 | F | 6 | | 1 | 0 | 0 | 1 | 1 | G | 1 | | 5 | 1 | 0 | 0 | 1 | H | 0 | | 7 | 1 | 0 | 0 | 1 | I | 5 | | 0 | 0 | 0 | 1 | 1 | J | 7 |
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!
| | |
ORLANDO, FLORIDA United States Member #5011 June 3, 2004 3293 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. | | |
Saskatchewan Canada Member #20314 August 9, 2005 2615 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!
| | |
|
