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.
Best Answer
You can also use a pivot table for this if you put a title in the cell above your list and then pivot (either in row or column) on your title cell and use count on your title field in the body (data) of the pivot table.