i am using the formula for count if =COUNTIF(A$2:$A2,A2) but it is displaying number for result can it be alphabet
<tbody>
</tbody>
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>