HI, Attached file has the hint. modify the file as per the requirments.
On Mon, Mar 2, 2009 at 8:11 AM, freeos <cnbi...@gmail.com> wrote: > > Dear all, > > I have a worksheet data (sheet1) > > Sheet1 > --------------------------------------- > Name direction CC DD > n1 left 1 2 > n1 left 3 4 > > n1 right 5 6 > n1 right 7 8 > n1 right 9 10 > > n2 left 11 12 > n2 left 13 14 > n2 left 15 16 > > n2 right 17 18 > n2 right 19 20 > n2 right 21 22 > -------------------------------------- > I hope to generate a new worksheet (Sheet2) based on Sheet1. > > Sheet2 looks like > -------------------------------------------------------- > Name odos CC_average DD_average > n1 left 2 3 > n1 right 10.5 12 > n2 left 24.5 21 > n2 right 29.5 31 > ------------------------------------------------------- > > I want to use SUMPRODUCT to realize it ,but I do not know how to do > it. > Would you please give me some hints? > Regards. > freeos > > > > > -- Thanks & Regards, Harmeet Singh --~--~---------~--~----~------------~-------~--~----~ ------------------------------------------------------------------------------------- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com ------------------------------------------------------------------------------------- -~----------~----~----~----~------~----~------~--~---
temp.xls
Description: MS-Excel spreadsheet
