View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Nat Maxwell Nat Maxwell is offline
external usenet poster
 
Posts: 13
Default Assign a number each letter on list compounding occurence @ each e

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!