Finding "oldest outstanding" item

[excelbeginner3]

Hi all, I'm after some more help with my spreadsheet - this time with finding some of the oldest outstanding of particular items

The spreadsheet below is an exert from the Master. I need to show the oldest date of items yet to be completed which is displayed in a 'metrics' table on another worksheet.

For example, I want it to generate the oldest, yet to be completed QUOTE/SPEC REQUEST/ GENERAL ENQUIRY

Is this a V look up or something else?

Thanks in advance for any help!

Received Via	Date received in CC	Type of request	Status	Date completed
Direct email to CC	14/11/2016	SPEC REQUEST	Complete	14/11/2016
	14/11/2016	GENERAL ENQUIRY	Complete
Customer	14/11/2016	GENERAL ENQUIRY	Complete	14/11/2016
	14/11/2016	GENERAL ENQUIRY	Complete	15/11/2016
Direct email to CC	14/11/2016	QUOTE REQUST	In progress
Direct email to CC	15/11/2016	COMPLAINT	In progress
Direct email to CC	15/11/2016	SPEC REQUEST	With Dean H
Online enquiry	16/11/2016	QUOTE REQUST	Complete	16/11/2016
Ralf	16/11/2016	SPEC REQUEST	Complete	17/11/2016
Marc	16/11/2016	SAMPLE REQUEST	In progress
Direct email to CC	16/11/2016	COMPLAINT	With Quality
Direct email to CC	17/11/2016	GENERAL ENQUIRY	Complete

<tbody>
</tbody><colgroup><col><col><col><col><col></colgroup>

 

[jorismoerings]

Hi,

Check if this what you're after:

Excel 2016 (Windows) 64 bit
	A	B	C	D	E
1	Received Via	Date received in CC	Type of request	Status	Date completed
2	Direct email to CC	14-11-2016	SPEC REQUEST	Complete	14-nov-16
3		14-nov-16	GENERAL ENQUIRY	Complete
4	Customer	14-11-2016	GENERAL ENQUIRY	Complete	14-11-2016
5		14-nov-16	GENERAL ENQUIRY	Complete	15-11-2016
6	Direct email to CC	14-11-2016	QUOTE REQUST	In progress
7	Direct email to CC	15-11-2016	COMPLAINT	In progress
8	Direct email to CC	15-11-2016	SPEC REQUEST	With Dean H
9	Online enquiry	16-11-2016	QUOTE REQUST	Complete	16-11-2016
10	Ralf	16-11-2016	SPEC REQUEST	Complete	17-11-2016
11	Marc	16-11-2016	SAMPLE REQUEST	In progress
12	Direct email to CC	16-11-2016	COMPLAINT	With Quality
13	Direct email to CC	17-11-2016	GENERAL ENQUIRY	Complete
14
15
16	QUOTE REQUST	14-11-2016
17	SPEC REQUEST	15-11-2016
18	GENERAL ENQUIRY
Sheet1

Cell Formulas
Range	Formula
B16	{=IF(MIN(IF((D2:D13<>"Complete")*(C2:C13=A16),B2:B13,""))=0,"",MIN(IF((D2:D13<>"Complete")*(C2:C13=A16),B2:B13,"")))}
B17	{=IF(MIN(IF((D2:D13<>"Complete")*(C2:C13=A17),B2:B13,""))=0,"",MIN(IF((D2:D13<>"Complete")*(C2:C13=A17),B2:B13,"")))}
B18	{=IF(MIN(IF((D2:D13<>"complete")*(C2:C13=A18),B2:B13,""))=0,"",MIN(IF((D2:D13<>"complete")*(C2:C13=A18),B2:B13,"")))}
Press CTRL+SHIFT+ENTER to enter array formulas.

nb: beware of the typo in "quote requst"