# ranking a set of values in Excel

I have a spreadsheet where cells, says A1 B1 C1 .....XX1 contains numerical values which are the result of some calculation
I want to have cells A2 B2 C2 ... XX2 containing the ranking (descending values) of corresponding values A1 B1 C1 ... XX1
For example with 5 cells A1 B1 C1 D1 E1 containing  12  23  98  33  10, cells A2 B2 C2 D2 D2 should contain 4  3  1  2  5
Is there a formula to calculate that ?
Thanks
LVL 1
###### Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Author Commented:
I forgot to write that some of these A1 B1 ... cells are empty and so should not participate to the ranking at all
0
Director, Practice Manager and Computing ConsultantCommented:
=IFERROR(RANK(A1,\$A\$1:\$A\$5),"")
0
Director, Practice Manager and Computing ConsultantCommented:
If you are using Excel 2003 or earlier:

=IF(A1="","",RANK(A1,\$A\$1:\$A\$5))
0

Experts Exchange Solution brought to you by

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Author Commented:
Thanks...
I use a french version of Excel
Do you know what the equivalent is for "rank()"
0
Director, Practice Manager and Computing ConsultantCommented:
RANG
0
Author Commented:
Found it : rang !
0