Try...

=SUMPRODUCT((H1:H1500<"")/COUNTIF(H1:H1500,H1:H1500&""))

Hope this helps!

In article ,
sudeepd12
wrote:

Please consider a long range of text cells containing A, B, C, D....Z
and more.

Lets say it goes from H1 to H1500

A -H1
A
B
F
D
A
H
D