PDA

View Full Version : Using Excel to tabulate the frequency of data



Renmoo
11-01-2010, 03:02 PM
Dear all

I have got a set of data which are arranged according to the following order in an Excel worksheet:

AA
AB
AA
AC
AB
AC
AC
AA
etc.

My question is how can I make Excel count the number of times "AA", "AB", and "AC" have appeared in that worksheet, and to display this information?

Cheers :)

fred_fish
11-01-2010, 03:09 PM
=COUNTIF(A1:A100,"AA") etc.

Renmoo
11-01-2010, 03:20 PM
Wonderful, thanks fred fish