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

[TABLE="width: 192"]
<tbody>[TR]
[TD="width: 64"]DATA[/TD]
[TD="width: 64"]COUNTIF[/TD]
[TD="width: 64"]REQUIRED[/TD]
[/TR]
[TR]
[TD="class: xl63"]AAA[/TD]
[TD="class: xl64"]1[/TD]
[TD="class: xl64"]A[/TD]
[/TR]
[TR]
[TD="class: xl63"]AAA[/TD]
[TD="class: xl64"]2[/TD]
[TD="class: xl64"]B[/TD]
[/TR]
[TR]
[TD="class: xl63"]AAA[/TD]
[TD="class: xl64"]3[/TD]
[TD="class: xl64"]C[/TD]
[/TR]
[TR]
[TD="class: xl63"]AAA[/TD]
[TD="class: xl64"]4[/TD]
[TD="class: xl64"]D[/TD]
[/TR]
[TR]
[TD="class: xl63"]AAA[/TD]
[TD="class: xl64"]5[/TD]
[TD="class: xl64"]E[/TD]
[/TR]
[TR]
[TD="class: xl63"]BBB[/TD]
[TD="class: xl64"]1[/TD]
[TD="class: xl64"]A[/TD]
[/TR]
[TR]
[TD="class: xl63"]BBB[/TD]
[TD="class: xl64"]2[/TD]
[TD="class: xl64"]B[/TD]
[/TR]
[TR]
[TD="class: xl63"]BBB[/TD]
[TD="class: xl64"]3[/TD]
[TD="class: xl64"]C[/TD]
[/TR]
[TR]
[TD="class: xl63"]BBB[/TD]
[TD="class: xl64"]4[/TD]
[TD="class: xl64"]D[/TD]
[/TR]
[TR]
[TD="class: xl63"]CCCC[/TD]
[TD="class: xl64"]1[/TD]
[TD="class: xl64"]A[/TD]
[/TR]
[TR]
[TD="class: xl63"]CCCC[/TD]
[TD="class: xl64"]2[/TD]
[TD="class: xl64"]B[/TD]
[/TR]
[TR]
[TD="class: xl63"]CCCC[/TD]
[TD="class: xl64"]3[/TD]
[TD="class: xl64"]C[/TD]
[/TR]
</tbody>[/TABLE]

 

[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