Tuesday, December 13, 2011

In Excel '03, how do I tally the number of occurrances of _each_ value in a column?

Data in column A. Type in cell B1 = countif(A:A,A1). Copy down as far as is needed. Will show totals of all seperate entities.

No comments:

Post a Comment