How to count number of occurences of each element within array

Hello to all,

How to count the ocurrences of each element within array?

For the sample array below, I'd like to store in an array or variables the number of a's, b's and c's, so the output would be:

Number of a´s = 4
Number of b´s = 1
Number of c´s = 2

Please Login or Register  to view this content.

Thanks in advance

The output is on active sheet A1.

Please Login or Register  to view this content.

Hello mikerickson,

Thanks for your answer. I'm trying and it seems to work. I'll test it within my code that has many values.

Hello AB33,

Thanks for your help too. It works well too.

One question,

Your output shows each value in difderent row, how to print the values (items) in the same row?

I've tried doing as below but is doesn't seem to be the best/direct way to do it.

Please Login or Register  to view this content.

Thanks again

If mean you want to swap columns for rows.

Please Login or Register  to view this content.

Hello AB33,

Thank you for your answer. I thought could be a more direct way to avoid the use of "transpose" twice, but I tried as below and doesn't work.

Please Login or Register  to view this content.

Thanks again.

You could use two lines if you want

Please Login or Register  to view this content.

Hello AB33,

In that way works perfect!.

Thanks so much.

Regards