Getting the count or # of occurrences of a value, but counting up to it

[joshuaba]

Hi guys,
I need help in trying to get a "rank" of text.
Let me explain.
I have a spreadsheet where column A has repeating values, while column B shows the rank/count of these values.

I have attached a screenshot of a simple example.

The letter A shows up a total of 3 times, and column B is counting 1,2,3. Meanwhile letter D is showing up 8 times, and counting 1 through 8.

Can you advise? I feel like there is a simple way of calculating this but I can't figure it out.

 

[awoohaw]

Not really sure what your question is. If column B is your expected result, then this. (If not please give an example of expected results).

Book2
	A	B
1	LETTER	SLOT/RANK
2	A	1
3	A	2
4	A	3
5	B	1
6	B	2
7	B	3
8	B	4
9	C	1
10	C	2
11	D	1
12	D	2
13	D	3
14	D	4
15	D	5
16	D	6
17	D	7
18	D	8
Sheet3

Cell Formulas
Range	Formula
B2:B18	B2	=COUNTIF($A$2:A2,A2)

 

[joshuaba]

Nevermind, I solved it with a modified countif...I knew it had something to do with it!

=COUNTIF($A$2:A2, A2)