Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
formula help to get oldest date in column based off another parameter
Hello, I am trying to retrieve the oldest date in an array of data if it matches a value in another column. For example, there are 4 column headings like this: A1: State B1: City C1: Count D1: Date A2: WA B2: Sea C2: 1 D2: 1/5/2006 A3: WA B3: Sea C3: 2 D3: 1/5/2006 A4: WA B4: Sea C4: 3 D4: 2/5/2006 A5: B5: Total C5: 6 D5: A6: State B6: City C6: Count D6: Date A7: WA B7: SPK C7: 2 D7: 12/5/2005 A8: B8: Total C8: 2 D8: A9: CA B9: LA C9: 10 D9: 2/15/2006 A10: B10:Total C10: 10 D10: A11 CA: B11:SA C11: 1 D11: 1/15/06 A12:CA B12: SA C12: 2 D12: 2/10/2006 A13: B13:Total C13: 3 D13: There also is other data that is not relavent to this. Anyways, I am trying to set up a formula to determine the oldest date based off of column A (State). In addition, there are blank cells between some of the data in each of the columns which need to be in the formula (Column A & D). The blank cells also seem to be giving me some problems. Here is the formula I currently have, which retrieves an invalid date is: =MIN((sheet1!$A$2:$A$500=Graph!G1)*(sheet1!$D$2:$D $500)) Note: Graph!G1 has a value of a state (column A) IN addition, I am trying to get the oldest date for all values in column D (All Dates). Any help would be greatly appreciated. Thanks! -- slimswol ------------------------------------------------------------------------ slimswol's Profile: http://www.excelforum.com/member.php...o&userid=32014 View this thread: http://www.excelforum.com/showthread...hreadid=517611 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Look for Oldest date among different dates | Excel Discussion (Misc queries) | |||
Working from oldest date | Excel Worksheet Functions | |||
Substracting from oldest date | Excel Discussion (Misc queries) | |||
Finding the oldest date in a column | Excel Worksheet Functions | |||
Find Oldest Date | Excel Discussion (Misc queries) |