i need a formula

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

i made a list of names in coloumn A, experience of each name in coloumn B sorted descending, and the age of each name in coloumn c
i need a formula in coloumn D that shows the age order of each name. for example:Edward has 10years experience and 35years old, he is the 1st experienced one, but he is the 4th aged one in the company, i need formula shows number
thanks
 
Hi
have a look at the RANK function
the formula
=RANK(D1,$D$1:$D$100,1)
and copy down
 
Back
Top