Excel Help Needed

Reply #7

Rakster — Tue, 27 Jul 2010 02:44:46 GMT

Thanks Raven

Reply #6

Raven62 — Mon, 26 Jul 2010 19:24:33 GMT

Cell A11 =RANK($A9,$A$9:$E$9,1) copy/paste into Cell B11 thru E11

Cell A12 =RANK($A9,$A$9:$E$9,1)

Cell B12 =RANK($B9,$A$9:$E$9,1)+COUNTIF($A$11:A$11,RANK($B$9,$A$9:$E$9,1) copy/paste into Cell C12 thru E12

Reply #5

Rakster — Mon, 26 Jul 2010 17:47:56 GMT

D1 D2 D3 total

1 0 1 2 3

2 0 1 1 2

3 1 1 2 4

4 1 0 2 3

5 0 2 0 2

6 0 0 0 0

7 1 1 0 2

8 2 0 0 2

9 2 1 0 3

0 0 0 0 0

Above is a list of digits (1-0) top down in bold.

The 1 was drawn a total of 3 times . Once in D2 (digit 2 position) and twice in D3 position for a total of 3 times.

The 2 was drawn a total of 2 times etc.

I want the DIGITS (1,2,3,4,5,6,7,8,9,0) to correspond to the number of times they were drawn... so the most to the least...

Reply #4

Rakster — Mon, 26 Jul 2010 17:28:08 GMT

Thank you all for your help. Its greatly appreciated

Reply #3

MzDuffleBaglady — Mon, 26 Jul 2010 17:12:35 GMT

Click on ascending order, or descending order, it can be found in the upper right hand corner of the ribbon, Sort and Filter button .

Click inside of the cell you want to sort, or the column.

Good Luck.

P.S. also try, Conditonal Formating ,

Yes, conditional formating.

You will have to set up the formula, for what you want,

8

6

etc.

and it will calculate it for you, but, you have to use, Conditional Formating to get the answer .

123 789

345 704... [ More ]

Reply #2

ACPutz — Mon, 26 Jul 2010 17:08:09 GMT

Don't know if I understand you correctly, but if you've got:

columns A B C D

Row #1 4 3 8 6

you can put this in order by typing:

=large(a1:d1,1)

tells the cell to look for the largest number in the array a1:d1

=large(a1:d1,2)

tells the cell to look for second largest number in same array

=large(a1:d1,3) - third largest and so on.

You can also do Small in the same format.

Hope that helps.

Reply #1

jimmy4164 — Mon, 26 Jul 2010 17:03:21 GMT

In my experience, what you are trying to do here is much more easily accomplished with a short, throw-away program in a language like GWBASIC. This is an old, legacy piece of software, but it allows you to write quick and dirty programs to scan Flat Files like the one you're dealing with easily. GWBASIC is available from numerous sites for free. Be sure you download it from a TRUSTED site! It consists of one executable image, requiring no installation, per se, and you can run it from the Command... [ More ]

Excel Help Needed

Rakster — Mon, 26 Jul 2010 14:48:55 GMT

Is there a way to get a column to organize a set of numbers from highest ranking to lowest by using data from an existing column?

For example...

1 (1 is in column A9) has 4 (4 is in column E9)hits

2 (2 is in A10) has 1 (1 is in E10) hit

3 has 6 hits

4 has 8 hits etc.

I want a new column to organize the 1,2,3,4 etc in an order according to the number of hits they had (8,6,4,2 etc)

Is there a formula to do this?

Thanks