auto- sequence number based on another column?

Originally Posted by NBVC

Try

=Countif(A$1:A1,A1)

copied down

where A1 is first entry to count.

Hello - this did not work guys . I am using MS 2010.... has anything changed?