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
on your macro.


capgunkidd < wrote:

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


---
Message posted from http://www.ExcelForum.com/