Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel as database
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 -- Message posted from http://www.ExcelForum.com |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel as database
Have a look at HELP index for COUNTIF
-- Don Guillett SalesAid Software "capgunkidd " wrote in message ... 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/ |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel as database
You may try a Pivot Table. In addition to Excel Help, there are some good
instructions he http://www.contextures.com/xlPivot01.html HTH Anders Silven "capgunkidd " skrev i meddelandet ... 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/ |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel as database
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/ |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel as database
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Update Excel Database via Access Main Database with a script | New Users to Excel | |||
Convert Excel database to dBASE database? | Excel Discussion (Misc queries) | |||
database query not showing foxpro database How I import data | New Users to Excel | |||
How to make reference to database and if true copy from database? | Excel Discussion (Misc queries) | |||
Moved database, how do I change link to the database in excel | Excel Discussion (Misc queries) |