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
.
.
.
.
K->H1500
I understand that to count the number of A's, we have:
=countif(=H1:H1500,"A")
Similarly, =countif(H1:H1500,"B") for B
.
.
.
.
But to this for every text is tedious.....
Is there a unique WAY which will actually give the count of each different text/number cells , once a range is selected.
Thanks for your time,
Sudeep
Bookmarks