If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|