Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Summarizing several item values in one cell
Hi,
I've done a ForEach procedure that updates an output list (based on names in column A, sheet Output) based on a database (names in column A and values in column B, Sheet Input). There can be several identical names in column A, sheet input. If there are several identical names in the "database", I want to summarize those values in the Output sheet for that name. (Now I only get the last number in the database) (Tom Ogily's suggestion resulted in the first value in the input sheet that matched) I appreciate any suggestion how to solve this? Thanks! Mats Westin |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Summarizing several item values in one cell
I posted a follow up that should do what you want. Try it and post back if
you have a problem. See your original post. By the way, this post is a lot clearer as to what the situation is. -- Regards, Tom Ogilvy "Mats Westin" wrote in message ... Hi, I've done a ForEach procedure that updates an output list (based on names in column A, sheet Output) based on a database (names in column A and values in column B, Sheet Input). There can be several identical names in column A, sheet input. If there are several identical names in the "database", I want to summarize those values in the Output sheet for that name. (Now I only get the last number in the database) (Tom Ogily's suggestion resulted in the first value in the input sheet that matched) I appreciate any suggestion how to solve this? Thanks! Mats Westin |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Summarizing a count of like values | Excel Discussion (Misc queries) | |||
How do I give numerical values to each text item in a list | Excel Discussion (Misc queries) | |||
Calculated Item in Pivot Table Adds Rows with Zero Values | Excel Discussion (Misc queries) | |||
CSV values and retrieiving nth item | Excel Worksheet Functions | |||
How to build a chart with 2 values per item? | Charts and Charting in Excel |