Hi,
Have a look at the attached to see if it does what you need. If you have 170,000 rows, that means 170,000 formulas, which may take a while for XL to calculate. Regards - Dave. > Date: Mon, 26 Jul 2010 22:29:05 -0700 > Subject: $$Excel-Macros$$ trouble with multiple formulas > From: nkmorri...@hotmail.com > To: excel-macros@googlegroups.com > > Can anyone provide me the formula/s for below query? I have four > columns. Company, Product, Date and Weight. What I need to do is add > up the monthly volumes per Customer/Product for each month. I have > over 170,000 records that I need to sort. I've tried multiple formulas > but I can't seem to work it out.Please help! > > Company Product Date Weight SHOULD EQUAL > ABC OW 2006/07 0.2 0.2 > ABC OW 2006/08 0.15 0.15 > ABC OW 2006/09 0.2 - > ABC OW 2006/09 0.1 0.3 > ABC OC 2006/10 0.1 - > ABC OC 2006/10 0.1 0.2 > ABC OC 2006/11 0.3 0.3 > ABC OC 2006/12 0.2 0.2 > ABC OC 2007/01 0.1 - > ABC OC 2007/01 0.2 0.3 > ABC PL 2006/07 0.2 0.2 > ABC PL 2006/08 0.2 0.2 > ABC DD 2006/08 0.2 0.2 > ABC PL 2007/04 0.2 - > ABC PL 2007/04 0.15 0.35 > ABC PL 2007/05 0.1 0.1 > HEALTH OW 2007/05 0.2 0.2 > HEALTH OW 2007/06 0.2 - > HEALTH OW 2007/06 0.2 0.4 > HEALTH OW 2007/07 0.2 - > HEALTH OW 2007/07 0.1 0.3 > HEALTH OW 2007/08 0.2 - > HEALTH OW 2007/08 0.2 - > HEALTH OW 2007/08 0.2 0.6 > HEALTH OW 2007/09 0.2 0.2 > HEALTH PL 2007/10 0.2 - > HEALTH PL 2007/10 0.2 0.4 > HEALTH PL 2007/11 0.3 - > HEALTH PL 2007/11 0.2 0.5 > DENTAL OC 2007/12 0.2 - > DENTAL OC 2007/12 0.2 0.3 > DENTAL OW 2008/01 0.15 0.15 > DENTAL PL 2008/01 0.2 0.2 > DENTAL DD 2008/02 0.1 - > DENTAL DD 2008/02 0.2 0.3 > DENTAL DD 2008/03 0.2 - > DENTAL DD 2008/03 0.2 0.4 > DENTAL DD 2008/04 0.1 0.1 > > -- > ---------------------------------------------------------------------------------- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > HELP US GROW !! > > We reach over 7000 subscribers worldwide and receive many nice notes about > the learning and support from the group.Let friends and co-workers know they > can subscribe to group at > http://groups.google.com/group/excel-macros/subscribe -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
Book1.xls
Description: MS-Excel spreadsheet
