View Single Post
  #1   Report Post  
bouncebackability bouncebackability is offline
Junior Member
 
Posts: 7
Question counting numbers??

probably not a suitable title...

ok my problem should be simple to explain.

i have in column B (from cells B2 to B20) 8 asterisks randomly placed(*)

what i want to do is in column A (A2 to A20), the first time that the star appears to write a '1' in the relative cell next to it, the second time it appears in the list a '2' the third time a '3' and so on... sounds simple and i thought it was. but im stumped. and dont know what to search for on here sorry :(

thanks for any help