You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


"george" wrote in message
...
Thanks All for your helps. Special Thanks to Valko and Barry, the forumlas
given by you works. Sorry for the delay in letting you, I had a trouble
in
finding this thread.
--
Thanks,
George


"T. Valko" wrote:

Another one:

=RANK(B2,B$2:B$15)+SUMPRODUCT(--(B2=B$2:B$15),--(A2<A$2:A$15))

--
Biff
Microsoft Excel MVP


"George" wrote in message
...
Hi All,

I have data in two rows I need to give ranking rule, based on quality
first
and then who is highest in production.

Production Quality
9300 100.00%
9310 99.99%
9320 99.98%
9330 99.97%
9340 99.96%
9350 99.95%
9360 100.00%
9370 99.99%
9380 99.98%
9390 99.97%
9400 99.96%
9410 99.95%
9420 100.00%
9430 99.99%

For Instance- If I choose Quality for Ranking, I wil get three 1st
ranks
based on quality 100%. But I want only three different ranks for the
analysts
based quality first and then on production. So I shld get 1st for
(9420 -
100.00%), 2nd for (9360 - 100.00%) and 3rd rank for (9300 - 100.00%).
Please
help

Thanks,
George