Counting query

  • Thread starter Thread starter KiwiBrian
  • Start date Start date
K

KiwiBrian

I have a list of 100 items in Column 1 with many duplicates.
In column 2 I wish to show how many times each item appears.
So each duplicate will have this number beside it in column 2.
What function/facility do I research to find how to do this?
Many thanks
Brian Tozer
 
Enter this in B1:

=COUNTIF(A:A,A1)

Now, select B1.
Hover the cursor over the lower right corner of B1 (small black square),
until the cursor changes from a fat white cross, to a skinny black cross.

Then, *double click*.

This will copy the formula in B1 down column B, as far as there is data in
column A.
 
Back
Top