Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to group date in pivot table | Excel Discussion (Misc queries) | |||
Need to find oldest date in ever changing list. | Excel Worksheet Functions | |||
Pivot table will not group a date field | Excel Discussion (Misc queries) | |||
Detecting Oldest Date On Spreadsheet | Excel Discussion (Misc queries) | |||
Subtotal of Subtotal displays Grand Total in wrong row | Excel Worksheet Functions |