Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
multiplying data
Hi,
I have two lists of data. List 1 is a person's name, their age group, and a sum of money. List 2 is a person's name, their age group, and a number. I'd like to match up the person's name and age group in list 1 with the same person's name and age group in list 2, and multiply the corresponding numbers. list 1 (money saved) Jane 5-10 $100 Bob 8-12 $50 Bob 10-12 $150 Mary 8-10 $100 Michael 10-12 $75 list 2 (interest rate) Mary 8-10 .5 Bob 8-12 .7 Results: Mary 8-10 $50 ($100x.5) Bob 8-12 $35 ($50x.7) How would be the best way to do this on a very large dataset? Ideally, it would be good also if this could be done from one dataset. I can put both list 1 and list 2 in the same pivot table style dataset with the following field headings, for example: name age group measurement value Mary 8-10 money saved $75 Mary 8-10 interest rate .5 Bob 8-12 interest rate .7 Bob 8-12 money saved $50 Looking forward to your ideas. Marina *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
multiplying | Excel Worksheet Functions | |||
Multiplying | Excel Worksheet Functions | |||
Multiplying specific data within a range to get column totals | Excel Worksheet Functions | |||
Multiplying a column of data by a constant | Excel Discussion (Misc queries) | |||
Multiplying in a row | Excel Discussion (Misc queries) |