04-30-2007, 10:25 AM
|
|
Forum Guru
|
|
Join Date: 12 Jan 2007
Location: New Jersey
Posts: 1,536
|
|
Quote:
|
Originally Posted by olasa
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
|
Olasa.... Interesting formula; however, I don't think that would work if the names were out of order. For example, if John Doe was added again after Ralph Smith, it would assing him a brand new number. Is there a way around that using your setup.
|