How to rank a combination of 2 or more columns?

[JenniferMurphy]

The first 2 columns in the table below are 5-star ratings, such as used on Amazon. I would like to rank them as a combined field sorted the way it is (Rating column Hi-Lo, # Reviews column Hi-Lo).

I discovered that the Rank functions only work with numbers, so the only thing I could think of was to create a helper column that generated a combined integer text string and then convert that to a number.

Is there a better way -- perhaps one that doesn't need the helper column?

Ranking.xlsx
	C	D	E	F	G
5	Rating	# Reviews	Rank	Helper	Rank2
6	4.9	11		4900000011	1
7	4.7	123,620		4700123620	2
8	4.7	18,604		4700018604	3
9	4.7	1,759		4700001759	4
10	4.6	38,086		4600038086	5
11	4.6	21,068		4600021068	6
12	4.6	17,787		4600017787	7
13	4.6	7,795		4600007795	8
14	4.6	7,540		4600007540	9
15	4.6	7,489		4600007489	10
16	4.6	4,864		4600004864	11
17	4.6	4,487		4600004487	12
18	4.6	3,778		4600003778	13
19	4.6	3,246		4600003246	14
20	4.6	2,883		4600002883	15
21	4.6	2,399		4600002399	16
22	4.6	327		4600000327	17
23	4.6	46		4600000046	18
24	4.5	44,427		4500044427	19
25	4.5	9,567		4500009567	20
26	4.5	5,801		4500005801	21
27	4.5	456		4500000456	22
28	4.4	8,509		4400008509	23
29	4.1	43		4100000043	24
Sheet1

Cell Formulas
Range	Formula
F6:F29	F6	=VALUE(TEXT([@Rating]*10,"0") & TEXT([@['# Reviews]],"00000000"))
G6:G29	G6	=RANK.EQ([@Helper],[Helper])

 

[Scott Huish]

Yes it is. I am the OP and I asked for a way to "Rank" them.

You posted a perfectly sorted list which is what I referenced. In that case a straight numerical list would give you the rank because they are already sorted, which is what I said but nobody read. The post has been deleted. You can stop worrying about it now. I'm sorry I got involved with this question.