I want to count a number of rows for each value appearing in a column. Is there an easy way to do this in excel?
Let's say I have the following table:
A B C 1 Cat A 3 Cat A 3 Cat B 4 Dog A 5 Cat B
I want to get the following result:
B Row_Count Cat 4 Dog 1
Also, it would be nice to be able to SUM
B SUM_Col_A Cat 12 Dog 4
But I cannot specify strings "Cat" and "Dog" explicitly because my columns contain >1000 distinct values.