# Help with Ranking?

#### MichaelRSnow

##### Active Member
Is it possible to rank based on 2 criteria, TEXT and VALUE. i.e. the table list as illustrated below, rank based on columns B and C. So rank any with a value of X only against X's, rank any with a value of Y only against Y's and so?</SPAN>
 A B C D- RANK (COLUMNS B&C) A X 0.5 2 A Y 1 1 A Z 1.5 2 B X 0.25 1 B Y 2 2 B Z 1.5 2 C X 0.85 3 C Y 2.25 3 C Z 1.25 1

<TBODY>
</TBODY>

### Excel Facts

Convert text numbers to real numbers
Select a column containing text numbers. Press Alt+D E F to quickly convert text to numbers. Faster than "Convert to Number"

#### FormR

##### MrExcel MVP
Hi, try:

Excel Workbook
ABCD
1ABCD- RANK (COLUMNS B&C)
2AX0.52
3AY11
4AZ1.52
5BX0.251
6BY22
7BZ1.52
8CX0.853
9CY2.253
10CZ1.251
Sheet1

#### snb_

##### Well-known Member
Maybe the array formula:

Code:
=RANK.EQ(\$C\$2,(\$B\$2:\$B\$10=\$B\$2)*\$C\$2:\$C\$10)

#### MichaelRSnow

##### Active Member
Hi, try:

Sheet1

 * A B C D 1 A B C D- RANK (COLUMNS B&C) 2 A X 0.5 2 3 A Y 1 1 4 A Z 1.5 2 5 B X 0.25 1 6 B Y 2 2 7 B Z 1.5 2 8 C X 0.85 3 9 C Y 2.25 3 10 C Z 1.25 1

<COLGROUP><COL style="WIDTH: 30px; FONT-WEIGHT: bold"><COL style="WIDTH: 64px"><COL style="WIDTH: 64px"><COL style="WIDTH: 64px"><COL style="WIDTH: 64px"></COLGROUP><TBODY>
</TBODY>

 Cell Formula D2 =COUNTIFS(\$B\$2:\$B\$10,B2,\$C\$2:\$C\$10,"<"&C2)+1

<TBODY>
</TBODY>

<TBODY>
</TBODY>

Excel tables to the web >> Excel Jeanie HTML 4

Thanks, works perfectly

Replies
1
Views
260
Replies
5
Views
242
Replies
10
Views
345
Replies
9
Views
359
Replies
30
Views
742

1,191,187
Messages
5,985,194
Members
439,947
Latest member
fabiannic

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back