LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 468
Default Pivot Table xl2007 Q

I currently have a PT in xl2007 with dates in my Column Data (From 1/01/2010
to 5/31/2010); I've currently filtered to show only 2/05/2010 to 2/25/2010
(the only actual February dates). How can I extract the Lowest current date
(2/05) and the Max Current date (2/25) out to cells D1 and D2 so when I
print the report these
dates are visible to the reader?

TIA,

Jim May
 
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
XL2007 - Pivot Table Limitations LPS Excel Discussion (Misc queries) 2 April 28th 10 04:46 PM
Pivot table XL2007: calculate difference between 2 columns ker_01 Excel Discussion (Misc queries) 0 September 17th 09 04:46 PM
XL2007: Pivot table date filter Scott Williams Excel Discussion (Misc queries) 1 May 29th 09 12:47 PM
Pivot Table Source Data - XL2007 Nate Excel Discussion (Misc queries) 0 February 25th 09 02:45 PM
XL2007 Pivot Table causes code to run slow? michael.beckinsale Excel Programming 3 November 3rd 08 01:13 PM


All times are GMT +1. The time now is 11:54 PM.

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

About Us

"It's about Microsoft Excel"