Auto sorting using Ranking and VLookup

[imanew]

Hey. I have followed the instructions on this page: http://www.auditexcel.co.za/Automatic Sorting Project.html.
As he said, I have a small problem because i have two numbers the same.

Excel Workbook
	A	B	C	D	E	F	G
1	*	*	*	*	*	Genre	Total Movies
2	1	TV	2	1	*	TV	2
3	2	Short	4	2	*	Short	4
4	3	Western	13	3	*	Western	13
5	4	Musical	26	4	*	Musical	26
6	4	Sport	26	5	*	#N/A	26
7	6	War	31	6	*	War	31
8	7	Biography	33	7	*	Biography	33
9	7	History	33	8	*	#N/A	33
10	9	Documentary	37	9	*	Documentary	37
11	10	Music	44	10	*	Music	44
12	11	Horror	90	11	*	Horror	90
13	11	Horror	90	12	*	#N/A	90
14	13	Mystery	93	13	*	Mystery	93
15	14	Animation	96	14	*	Animation	96
16	15	Romance	119	15	*	Romance	119
17	16	Family	127	16	*	Family	127
18	17	Sci-Fi	133	17	*	Sci-Fi	133
19	18	Fantasy	164	18	*	Fantasy	164
20	19	Crime	195	19	*	Crime	195
21	20	Adventure	228	20	*	Adventure	228
22	21	Action	305	21	*	Action	305
23	22	Drama	308	22	*	Drama	308
24	23	Comedy	310	23	*	Comedy	310
25	24	Thriller	337	24	*	Thriller	337
Select Movie By Genre

Any ideas on how to get around this?

 

[JoeMo]

One way to break ties is to insert a column before column D (so the new column is now column D), then enter in D2:
=C2+.0000001*ROW()
Then pull this down to D25. Then in A2 insert:
=RANK(D2,$D$2:$D$25,1)
and pull down to A25.

 

[imanew]

That's brilliant. So simple and works perfectly.