Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 1
Default EXCEL Dinamica Tabs

How can y group dates (Days) in months
  #2   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 2,510
Default 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

  #3   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 2,480
Default 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



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel Tabs dbs Excel Discussion (Misc queries) 4 October 17th 07 08:07 PM
Can i set up tabs within tabs on Excel? Gizelle Excel Worksheet Functions 5 October 30th 06 12:52 PM
excel tabs matt Charts and Charting in Excel 0 August 1st 05 09:57 PM
How can I use the tabs in excel Micheline Excel Discussion (Misc queries) 3 April 15th 05 06:06 PM
excel tabs sandlapper Excel Worksheet Functions 4 April 12th 05 04:39 PM


All times are GMT +1. The time now is 02:35 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"