ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   EXCEL Dinamica Tabs (https://www.excelbanter.com/new-users-excel/165987-excel-dinamica-tabs.html)

Group

EXCEL Dinamica Tabs
 
How can y group dates (Days) in months

OssieMac

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


Roger Govier[_3_]

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