Getting the earliest and latest date in Pivot Table

**dluhut** · 05-02-2013, 12:05 PM

Hello excel experts,

Is there a formula that could look at pivot table and get the earliest date and latest date?

I've attached a sample, but will still put it here for what i mean.

ID Beg.Date End Date
abc Jan 1, 2010 June 30, 2010
bcd Feb 15, 2010 Nov 30, 2010
Dec 1, 2010 May 30, 2012
cde Apr 17, 2010 Dec 31, 2012

Assume above is a pivot table...notice that bcd has 2 pair dates (2 beginning date and 2 end date).

Is there a formula/function (match, vlookup etc) that could take Feb 15, 2010 as the beginning date and May 30, 2012 as the end date for ID "bcd"??

**FDibbins** · 05-02-2013, 01:54 PM

Assume above is a pivot table...notice that bcd has 2 pair dates (2 beginning date and 2 end date).

actually, i dont see that, sorry?

and the data you have here, bears no resemblance to what's in the file you uploaded?

Do you mean that A14 and A15 are the same ID, and you want to find 7/19/200 (earliest) and 11/26/2004 (Latest) for that ID?
where would you want this info put?

I suggest that you add some sample answers to your file, so we can see what you want, and explain how you got that, so we can figure out how to do it

Getting the earliest and latest date in Pivot Table

LinkBack

Thread Tools

Rate This Thread

Display

Getting the earliest and latest date in Pivot Table

Re: Getting the earliest and latest date in Pivot Table

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions