Excel puts ranked column of cells in wrong order used =MATCH(LARGE(D:D,ROW()),D:D,FALSE)

Attached is book 2.

Column D should read:

01
04
05
03
02

but instead it reads:

01
05
04
02
03

Obviously I have done something wrong.

Thank you in advance for your assistance in correcting my error,
Leonard

Change your formula in C1 to this:

=IF(C1="","",(RANK(C1,$C$1:$C$15,1)))

then copy down. Note there is an optional 3rd parameter for the RANK function, which controls whether you want increasing or decreasing rank.

Hope this helps.

Pete