Hi Ivan,
Am Sat, 24 Jan 2015 10:42:12 +0100 schrieb Claus Busch:
if column A is sorted ascending try in B1:
=RANK(A1,$A$1:$A$33,1)
and in B2:
=IF(A2=A1,B1,B1+1)
and copy down
Is column A sorted descending try in B1:
=RANK(A1,$A$1:$A$33,0)
if you use a helper column sorting does not matter.
Please have a look:
https://onedrive.live.com/?cid=9378A...121822A3%21326
for "Rank"
Regards
Claus B.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional