On Tue, 27 Feb 2007 11:50:05 -0800, 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!

If your first entry is in cell A1, then:

B1: =COUNTIF($A$1:A1,A1)

and copy/drag down as far as required.

This should give you the count you are looking for
--ron