will sth. like (insert the formula in 1st row):

=LARGE(IF($B$1:$B$50=100%,$A$1:$A$50,),ROW())&" - 100%"

help?

CTRL+SHIFT+ENTER this formula as it is an array-formula


On 29 Gru, 14:46, George wrote:
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