Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
help how to crate group of date with Dynamic Range?
Hi
I am useing Pivot Table to create data where i am useing Data,Party Name,Group,Wt.,Rate,Amt. In this Data i have given range name (database) with Dynamic Range =OFFSET(Sheet1!$A$5,0,0,COUNTA(Sheet1!$A:$A),6) But when i use Date in report i try to create Group of date in month or year or day and qty it says can't create a gorup? Any help how to crate group of date, with Dynamic Range? Thanks Tiya |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I create a schedule from a list of dates ? | Charts and Charting in Excel | |||
How do I count items within a date range in Excel? | Excel Worksheet Functions | |||
HELP - Date Range In 1 Cell Calculation | Excel Worksheet Functions | |||
overtime formula based on dynamic date range? | Excel Worksheet Functions | |||
Subtotal of Subtotal displays Grand Total in wrong row | Excel Worksheet Functions |