how to rank multiple values in single column according to how often value is duplicated

I don't think the histogram works on non-numeric data.

So examine the attached.

This was done by the following steps;

1. Copy the data to column C.
2. Remove the duplicates from column C only. (Function under the data tab).
3. In column B, add the function =Countif(range, C1) range is the range in column A(use absolute refs).
4. Then fill-down the countif function.