tags:

views:

16

answers:

0

I have an Excel worksheet with one column of cells with any string values, so, like this: A, B, A, D, C, C, A, A. What I am wanting to do is to count how many times each value occurs and print that out on some other cells, like: A:4, B:1, C:2, D:1. I don't mind if these are spread across 2 columns. I also want to order these, with the most frequent first, like: A:4, C:2, B:1, D:1. How should I go about doing this?

Edit: I also do not know what values will occur.