Thread: How do you auto number?
View Single Post
  #2  
Old 04-30-2007, 01:36 AM
BigBas BigBas is offline
Forum Guru
  
Join Date: 12 Jan 2007
Location: New Jersey
Posts: 1,536
BigBas is becoming part of the community
This is one way to do it:

I put a number 1 in the first row. Then in cell A2 (this is assuming the numbers are in column A, and names in B):

Code:
=IF(B2="","",IF(COUNTIF($B$1:B2,B2)>1,INDEX($A$1:A1,MATCH(B2,$B$1:$B$100,0)),MAX($A$1:A1)+1))
Try that and let me know if it works.

EDIT to add: You can fill that formula down as far as necessary. If there is no name in the corresponding cell in column B, it will return blank.
Reply With Quote