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!

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

In B1 enter:
1
In B2 enter:
=IF(A2=A1,B1+1,1)
and copy down
--
Gary''s Student
gsnu200708


"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!

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!

Thank you all very much! Will try out all three methods.
Have a wonderful day!

"Teethless mama" wrote:

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!