Rank Subsets of Data by Multiple Criteria

[Noz2k]

I'd like to rank data within groups, by multiple values (in a hierachy), so if Value1 is equal between 2 elements in the same group then rank by column 2, 3, etc
e.g. the data would appear like this where ranking in descending order:

Group	Value1	Value2	Rank
A	10	4	3
A	12	4	1
A	10	5	2
B	10	3	3
B	11	4	2
B	15	2	1
C	12	4	2
C	12	3	3
C	14	5	1

Note, the group sizes may not be the same, and the data may not be ordered by group (I've just done that for ease of reading).

Thanks,

 

[jasonb75]

This gives the same results as the example but I'm not entirely convinced that it will be accurate with larger data sets. Also, the wording in your question has me thinking that there could be more value columns as well, if that is the case then I have a feeling that this it could be heading towards destination impossible.

Book2
	A	B	C	D
1	Group	Value1	Value2	Rank
2	A	10	4	3
3	A	12	4	1
4	A	10	5	2
5	B	10	3	3
6	B	11	4	2
7	B	15	2	1
8	C	12	4	2
9	C	12	3	3
10	C	14	5	1
Sheet5

Cell Formulas
Range	Formula
D2:D10	D2	=COUNTIFS(A:A,A2,B:B,">"&B2)+COUNTIFS(A:A,A2,B:B,B2,C:C,">="&C2)