Hello,
I am looking for a formula that will find the last date entered in an array (note that the last date is needed, not the latest date).
In the first table contain, an accounting period (i.e., Period 1, Period 2) is entered in Column A (A2:A7) and a date is entered in Column B (B2:B7). Column B may also contain some text other than dates.
The second table lists all of the possible accounting periods in Column A (A10:A13). These periods will match the accounting periods entered in Column A in the first table. Column B of this table (B3:B13) is where I would like a formula that will pick up the last date entered in Table 1 for each of the accounting periods, ignoring any other text that may be there.
I’m including a little illustration in case what I said doesn’t make sense.
Table 1
Col. A Col. B
Period 1 1/1/17
Period 2 2/5/17
Period 1 4/30/17
Period 1 (check with PM)
Period 3 3/1/17
Period 4 4/1/17
Period 3 1/30/17
Period 3 (check with PM)
Table 2
Col. A Col. B
Period 1 4/30/14
Period 2 2/5/17
Period 3 1/30/17
Period 4 4/1/17
Thank you!
Bookmarks