Assign a number each letter on list compounding occurence @ each e

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!
 
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!
Click to expand...

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
 
Assuming your data in Sheet1
Create a name range. Example: ALPHA

In Sheet2
In A1:
=IF(ISERR(SMALL(IF(ALPHA="A",ROW(INDIRECT("1:"&ROWS(ALPHA)))),ROWS($1:1))),"",INDEX(ALPHA,SMALL(IF(ALPHA="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
 
Back
Top