Previous Topic Next Topic

Excel formula

Closed
murtaza lakhani - 22 Jun 2009 à 06:28
mubashir aziz Posts 190 Registration date Sunday 12 April 2009 Status Member Last seen 16 February 2010 - 23 Jun 2009 à 00:05
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 response

Réponse 1 / 1
mubashir aziz Posts 190 Registration date Sunday 12 April 2009 Status Member Last seen 16 February 2010 166
23 Jun 2009 à 00:05
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 ......

Similar discussions

How to calculate positions (1st,2nd,3rd...) in Excel
hardy -
TrowaD -

6 responses
How to calculate position (1st,2nd,3rd) in excel....?
abdulwajid -
TrowaD -

1 response
Calculation of positions in excel
Mohsin -
Dausayi -

12 responses
Auto generate serial number in excel based on Column
Raj_1562 -
TrowaD -

4 responses