Countif Function Help

[Safi.]

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]

=COUNTIF($A$1:A1,A1)

copy down


--


Regards,


Peo Sjoblom