Assuming your data in Sheet1
Create a name range. Example: ALPHA

In Sheet2
In A1:
=IF(ISERR(SMALL(IF(ALPHA="A",ROW(INDIRECT("1:"&ROW S(ALPHA)))),ROWS($1:1))),"",INDEX(ALPHA,SMALL(IF(A LPHA="A",ROW(INDIRECT("1:"&ROWS(ALPHA)))),ROWS($1: 1))))

Copy across, all you have to change a letter "A" on the second column to
"B" and so on...
then copy down


"Nat Maxwell" wrote:

hi all,
What should be the syntax if I have a list of first letters of my entries
(looking something like
A
A
B
C
C
C
C
E
J
P
P
P
S
S
T
V

and I wanted to programmatically assign a number to each entry on this list,
restaring the numbering at each letter (e.g., first A would appear as A1,
second as A2, first C as C1, fifth C as C5, etc.)? I know how to compile the
resulting letter with its corresponding numeral, I'm just not sure how/if to
use the MATCH function to count the compounding occurence of each letter on
the list.
Thank you in advance!