Excel 2003 rank with 2 or more criterias

Hello,

I got the following table, and I am able to rank them:

-	A	B	C	D	E
1	1st	Name1	100	100	3
2	2nd	Name2	100		2
3	3rd	Name3	100	90	5
4	4rd	Name4	100	100	1
5	5th	Name5	71	100	3
6	6th	Name6	60	100	2

Now, they are ranked based on column D, but there are a lot with the same result (100), if they are equal I would like to rank them on a second criteria (column E) and if both are equal then a third criteria (column F), if this is possible, but my main concern is to rank on 2 criterias.

Correct way would be:

-	A	B	C	D	E
1	1st	Name1	100	100	3
2	2nd	Name4	100	100	1
3	3rd	Name3	100	90	5
4	4rd	Name2	100		2
5	5th	Name5	71	100	3
6	6th	Name6	60	100	2

Thank you very much in advance for your help.

Serge

I would suggest adding a column (F)(you can hide it if you like)
=D2*1000+E2
Then rank on F
You can do this as many times as you like just make sure that the numbers magnitude don't intersect each other
=D2*1000000 + E2 *1000 + F2 for example

In essence, you want a rank with 2 tie-breakers.

Can you post more data showing the values in column F plus the resulting ranks that you expect?