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
160
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