Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3
Default 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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 27,285
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Summarizing a count of like values Matt Excel Discussion (Misc queries) 1 June 27th 09 12:34 AM
How do I give numerical values to each text item in a list Tomj37 Excel Discussion (Misc queries) 1 August 4th 08 07:21 PM
Calculated Item in Pivot Table Adds Rows with Zero Values Marc Forget Excel Discussion (Misc queries) 0 July 16th 07 06:24 PM
CSV values and retrieiving nth item Christopher Short Excel Worksheet Functions 1 January 26th 06 06:01 PM
How to build a chart with 2 values per item? Boaz Weiss Charts and Charting in Excel 4 December 3rd 04 03:33 AM


All times are GMT +1. The time now is 12:49 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"