Excel formula [Closed]

Report
-
mubashir aziz
Posts
191
Registration date
Sunday April 12, 2009
Status
Member
Last seen
February 16, 2010
-
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

Posts
191
Registration date
Sunday April 12, 2009
Status
Member
Last seen
February 16, 2010
210
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 ......