| Forum Home | ||||
| Press F1 | ||||
| Thread ID: 106495 | 2010-01-11 02:02:00 | Using Excel to tabulate the frequency of data | Renmoo (66) | Press F1 |
| Post ID | Timestamp | Content | User | ||
| 847761 | 2010-01-11 02:02:00 | 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 :) |
Renmoo (66) | ||
| 847762 | 2010-01-11 02:09:00 | =COUNTIF(A1:A100,"AA") etc. | fred_fish (15241) | ||
| 847763 | 2010-01-11 02:20:00 | Wonderful, thanks fred fish | Renmoo (66) | ||
| 1 | |||||