EXCEL Dinamica Tabs
How can y group dates (Days) in months
|
EXCEL Dinamica Tabs
Hi,
Don't understand your question. Can you post a sample of the data plus a sample of what you want it to look like after manipulation. -- Regards, OssieMac "Group" wrote: How can y group dates (Days) in months |
EXCEL Dinamica Tabs
Hi
I am assuming that Dinamica Tabs are Pivot Tables in the UK/US versions of Excel. If that is the case, then highlight any Date value on the tableright clickGroup and Show DetailGroupMonthsOK Note that all items within the Date filed must be true Excel dates and not text representations of dates, and there must be no blank cells within the range, otherwise Excel will display a message saying it Cannot Group by that item. -- Regards Roger Govier "Group" wrote in message ... How can y group dates (Days) in months |
All times are GMT +1. The time now is 12:16 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com