Sort Problem
Dear All,
I have a worksheet that contains sales data by months like this: JUL AUG YTD Cust. Name - Sales - COS - GP Sales - COS - GP Sales - COS - GP I want to sort YTD category by GP column but it seems its not working categories JUL AUG & YTD are merge cells for each 3 columns under them, I also try with normal cells for each category but not found correct results, one more thing I would like to share that sales - COS - & GP amount are retrieved via sumproduct formula where cust. Name & Month are conditions, please help me out :) |
All times are GMT +1. The time now is 05:51 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com