the countif function when applied it returns the values in decending order of
the repitions where as i wanted to have it in ascending order of the
repeations...i.e the frist in the data is 1..2.3...like this not like
3...2...1.. which make the lastest given the 1 and the oldest which is at the
top/beginging of the sheet is given 3.. which i dont want .,..any help to fix
this prblm
Thanks,
safi
Peo Sjoblom - 28 May 2008 15:47 GMT
=COUNTIF($A$1:A1,A1)
copy down

Signature
Regards,
Peo Sjoblom
> the countif function when applied it returns the values in decending order
> of
[quoted text clipped - 8 lines]
> Thanks,
> safi