Previous Topic Next Topic

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 response

Answer 1 / 1
mubashir aziz Posts 190 Registration date Sunday April 12, 2009 Status Member Last seen February 16, 2010 166
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

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
formulas for 1st and 2nd position in class
jack -
suff954 -

1 response