Ranking with letters

[Jovica]

Is there a function like rank() that enables ranking with letters e.g, A-F?

[oeldere]

Why not use sorting A to F?

[Jovica]

I don't need to sort values I need to compare them (numerical values) and give rank to the reference values, but rank() just doesn't look good to me. I could replace 1-7 ranking results with A-G via IF function but I thought that there must be some other solution. And besides that I'm trying to avoid unnecessary nesting with if function 'cause my workbook calculations are already so slow.

[oeldere]

I bet you get better help if you add an excel file without confidentional information.

[Haseeb Avarakkan]

One way is to use CHAR function.

=CHAR(Your_Rank_Formula+64)

[Jovica]

Char() function is working like charm, thank you so much.

[Haseeb Avarakkan]

CHAR() only give you betwen A-Z, if you want to return AA, Ab etc. then,

=SUBSTITUTE(ADDRESS(1,Your_Rank_Formula,4),1,"")

Will work in Excel 2007 or higher A-XFD

Excel 2003 A-IV