Excel Question

Reply #7

Rakster — Sat, 11 Apr 2009 23:51:30 GMT

Thanks

Reply #6

CARBOB — Sat, 11 Apr 2009 22:34:45 GMT

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.

Reply #5

Rakster — Sat, 11 Apr 2009 20:30:25 GMT

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.

Reply #4

CARBOB — Sat, 11 Apr 2009 14:39:13 GMT

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

Reply #3

Rakster — Sat, 11 Apr 2009 13:54:09 GMT

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 ask... [ More ]

Reply #2

Rakster — Sat, 11 Apr 2009 12:35:58 GMT

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

Reply #1

time*treat — Sat, 11 Apr 2009 06:46:31 GMT

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

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

Excel Question

Rakster — Sat, 11 Apr 2009 05:55:24 GMT

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... [ More ]