Thread: How do you auto number?
View Single Post
  #6  
Old 04-30-2007, 09:25 PM
mikerickson mikerickson is offline
Forum Moderator
  
Join Date: 30 Mar 2007
Location: Davis CA
MS Office Version:Excel 2004
Posts: 2,323
mikerickson is very confident of their ability mikerickson is very confident of their ability mikerickson is very confident of their ability
in A2

=IF(B2=B1,A1,A1+1)

works for me.
Last edited by mikerickson; 04-30-2007 at 09:31 PM.
Reply With Quote