Generate a column of numbers and letters

Your post does not comply with Rule 8 of our Forum RULES. Do not crosspost your question on multiple forums without including links here to the other threads on other forums.

Cross-posting is when you post the same question in other forums on the web. The last thing you want to do is waste people's time working on an issue you have already resolved elsewhere. We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the url from the address bar in your browser) to the cross-post.

Expect cross-posted questions without a link to be closed and a message will be posted by the moderator explaining why. We are here to help so help us to help you!

Read this to understand why we ask you to do this, and then please edit your first post to include links to any and all cross-posts in any other forums (not just this site).

How many times can a name be duplicated?

1z

If it's more than 26 then what?

See the cross post here, Tony: http://www.excelguru.ca/forums/showt...rs-and-letters

I offered a solution, but have heard nothing more.

Here's how I did it...

Data Range

	A	B
1	Name	Code
2	Tom	1a
3	Tom	1b
4	Tom	1c
5	Phil	2a
6	Phil	2b
7	John	3a
8	Jerry	4a
9	Dave	5a
10	Karen	6a
11	Karen	6b
12	Karen	6c
13	Karen	6d

This formula entered in B2 and copied down:

=IFERROR(--LEFT(B1,LEN(B1)-1),0)+(A2<>A1)&CHAR(COUNTIF(A$2:A2,A2)+96)

Assumes the names will be sorted/grouped as is demonstrated in the top post.