LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Jim May
 
Posts: n/a
Default Lookup Oldest date from previously selected Group Data

Sample Data (table)

A B C D
1 APM xxxxxxxxxxx 1/15/05 2.00
2 APM xxxxxxxxxxx 2/28/05 2.00
3 APM xxxxxxxxxxx 1/13/05 2.00
4 APM xxxxxxxxxxx 12/4/04 2.00
5 APM xxxxxxxxxxx 3/15/05 2.00
6 APM xxxxxxxxxxx 4/20/05 2.00
7 APM Total 12.00
8 GPS xxxxxxxxxxx 4/13/05 3.00
9 GPS xxxxxxxxxxx 4/10/05 3.00
10 GPS xxxxxxxxxxx 4/5/05 3.00
11 GPS xxxxxxxxxxx 12/15/04 3.00
12 GPS xxxxxxxxxxx 11/27/04 3.00
13 GPS xxxxxxxxxxx 3/10/05 3.00
14 GPS Total 18.00
Above on Sheet1

On my Sheet 2
Cell D4 = GPS
Cell F4 = =SUMIF(Sheet1!$A$1:$A$13,sheet2!$D$4,Sheet1!$D$1:$ D$13)
which displays 18
In Cell F5 i need to Bring back the oldest date in the same GPS group, the
answer 11/27/04,,, Can someone help me?

Tks in advance..


 
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
How to group date in pivot table Minh Le Excel Discussion (Misc queries) 1 March 4th 05 01:55 AM
Need to find oldest date in ever changing list. Alan Anderson via OfficeKB.com Excel Worksheet Functions 5 February 20th 05 04:09 AM
Pivot table will not group a date field Mary Excel Discussion (Misc queries) 2 February 17th 05 02:53 AM
Detecting Oldest Date On Spreadsheet Keiron James Keeble Excel Discussion (Misc queries) 3 January 19th 05 01:09 AM
Subtotal of Subtotal displays Grand Total in wrong row Thomas Born Excel Worksheet Functions 5 January 6th 05 01:46 PM


All times are GMT +1. The time now is 12:46 AM.

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"