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 --~--~---------~--~----~------------~-------~--~----~ ------------------------------------------------------------------------------------- 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 ------------------------------------------------------------------------------------- -~----------~----~----~----~------~----~------~--~---
