Trying to count the number of times a name appears / table

[Terry]

Hi ,
I'm using Excel 2000 and im trying to count the number of times a name
appears on the sheet ( column) and thereafter creating the results in a table
format.
Here's my example :

Company name
Comp A
Comp B
Comp C
Comp A
Comp A

and wanting the results to be like :

Company name No of files
Comp A 3
Comp B 1
Comp C 1

Look forward to hearing from you'll. Thank you !

br,Terence

 

[Jacob Skaria]

You can try the below..

1. Select the range in Col A (companies) including the header.
2. Data>Filter>Advanced Filter>Copy to another location
3. In copy to I have selected D1 and check 'Unique records only'
4. Click OK will give you the unique list of companies.
5. In E2 apply the below formula

=COUNTIF(a:a,d2)
and copy that down as required

Copy that to J2 and K2
Drag down as required.


If this post helps click Yes

 

[Ashish Mathur]

Hi,

It would be easiest to create a pivot tale here (no functions required).
Drag company name to row area and then drag company name to the data area
again

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

 

[Teethless mama]

Sort your data first then use SUBTOTAL command in the menu

 

[Terry]

Hi guys,

Thank you for the prompt response. The Pivot table worked. One of the
problems i initially faced with it was the dragging and dropping the
respective data. Perhaps Microsoft could look into making it more layman
freindly.

Thanks again !

br,Terence