Thread: How do you auto number?
View Single Post
  #3  
Old 04-30-2007, 04:58 AM
olasa olasa is offline
Forum Guru
  
Join Date: 24 Dec 2004
Location: Sweden
Posts: 1,081
olasa is becoming part of the community
Increment by one
If the names are entered in identical ways, meaning that John Doe is not written John, Doe or Doe, John, the below can be used.

I let the names start in A1, so I put 1 in B1.
Then I put =B1--(A1<>A2) in B2, and copy the formula downward.
Done

//Ola

Code:
John Doe           1                  -->1
John Doe           =B1--(A1<>A2)       -->1
Jane Doe           =B2--(A2<>A3)       -->2
Frank Johnson     ....                       
Ralph Smith
Ralph Smith
Ralph Smith
Reply With Quote