Thanks for the quick revert Andy I've enclosed a workbook. Not sure if the workbook makes it to the group, so added a cc to your e mail as well
This work book has two sheets. One called Original data and another sheet called desired results. I have made some notes on the desired results on what I wish to see. The original data sheet has the criteria range and sum ranges Hope I've made myself clear Thanks &Regards Subu New Email names for you! Get the Email name you've always wanted on the new @ymail and @rocketmail. Hurry before someone else does! http://mail.promotions.yahoo.com/newdomains/aa/ --~--~---------~--~----~------------~-------~--~----~ ------------------------------------------------------------------------------------- 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 ------------------------------------------------------------------------------------- -~----------~----~----~----~------~----~------~--~---
SS Query - sample to mac gr.xls
Description: MS-Excel spreadsheet