counting with character in count if formula

[sachin483]

i am using the formula for count if =COUNTIF(A$2:$A2,A2) but it is displaying number for result can it be alphabet

DATA	COUNTIF	REQUIRED
AAA	1	A
AAA	2	B
AAA	3	C
AAA	4	D
AAA	5	E
BBB	1	A
BBB	2	B
BBB	3	C
BBB	4	D
CCCC	1	A
CCCC	2	B
CCCC	3	C

<tbody>
</tbody>

 

[Fluff]

Try
=CHAR(COUNTIF(A$2:$A2,A2)+64)
this will only work up to Z

 

[FDibbins]

COUNTIF returns a numeric value - it counts records that match your criteria. What kind of answer are you expecting?

 

[sachin483]

i was using reverse count if and instead of numeric i wanted character thanks