Ranking

P

pkbravo

i have percentages on six sheets of a work book.
on the 7th sheet. i want to rank these percentages from lowest
to highest. i've tried using the SMALL function but cannot get it t
work.
here's the formula. any help would be greatly appreciated :confused:


=SMALL((cincinnati!L58,atlanta!L59,perimeter!L58,'ston
point'!L59,newport!L59),1
 
P

Pedro

I'm not an expert but i've tried to funcion Rank(on the column %) and it
works fine with me
 
Top