Excel formula

Closed
murtaza lakhani - Jun 22, 2009 at 06:28 AM
mubashir aziz Posts 190 Registration date Sunday April 12, 2009 Status Member Last seen February 16, 2010 - Jun 23, 2009 at 12:05 AM
Hello,
my difficult is that i need a formula in which position should be given higher ranker first if i use if's formula and there are three person who got 90 above marks so the all will get the first position and i want a formula in which higher marker one get first position second higher marker got second position and third higher marker got third position.

1 reply

mubashir aziz Posts 190 Registration date Sunday April 12, 2009 Status Member Last seen February 16, 2010 161
Jun 23, 2009 at 12:05 AM
use Rank() function to get the result .... suppose your data is in Column A from A2 to a6 then in B2 write this formula and drag it down ...

=Rank(A2,$A$2:$A$6) and drag it down ......

0