Excel as database

[capgunkidd]

I am having trouble with this task. I need to go through a list o
products find all of the different item names, count each of thes
items as many times they appear on the list and display these values i
another cell. This must be completely automated, except entering th
list. Any help you guys could give me will be greatly appreciated

 

[Don Guillett]

Have a look at HELP index for COUNTIF

 

[Anders S]

You may try a Pivot Table. In addition to Excel Help, there are some good
instructions here:
http://www.contextures.com/xlPivot01.html

HTH
Anders Silven

 

[JWolf]

Assuming the list of products is in column A:
On main menu: Data-->Filter-->Advanced Filter
Select: Copy to another location
In List Range enter: A:A
In Copy to enter: G:G (or some other blank column)
Select Unique records only
Click OK
In H1 enter the forumula: =COUNTA(A:A,G1)
Copy the formula down coumn H to the last row in G.

Turn on the Macro Recorder and do these steps again to get you started

 

[capgunkidd]

thanks a lot everyone. i got it working