Home |
Search |
Today's Posts |
#5
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
thanks.
I was fairly surprised a pivot table didn't handle that better. but the array formulas have it going. "Ashish Mathur" wrote: Hi, I would have suggested method 3 (of your mail), had my previous solution not worked. Anyways, I am glad you figures it out -- Regards, Ashish Mathur Microsoft Excel MVP www.ashishmathur.com |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel Pivot Table How to Sort data as Percent of Row | Excel Worksheet Functions | |||
How do I calculate "cummulative percent of total" in a pivot table | Excel Discussion (Misc queries) | |||
Percent (field1/ field2) on pivot table | Excel Discussion (Misc queries) | |||
Pivot table question: How to display total and percent for data simultaneouly | Excel Discussion (Misc queries) | |||
Pivot Table Question : If statment in Pivot Table?? | Excel Discussion (Misc queries) |