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!


[TABLE="width: 1109"]
<tbody>[TR]
[TD]Received Via[/TD]
[TD]Date received in CC[/TD]
[TD]Type of request[/TD]
[TD]Status [/TD]
[TD]Date completed[/TD]
[/TR]
[TR]
[TD]Direct email to CC [/TD]
[TD]14/11/2016[/TD]
[TD]SPEC REQUEST[/TD]
[TD]Complete [/TD]
[TD]14/11/2016[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]14/11/2016[/TD]
[TD]GENERAL ENQUIRY[/TD]
[TD]Complete [/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Customer[/TD]
[TD]14/11/2016[/TD]
[TD]GENERAL ENQUIRY[/TD]
[TD]Complete [/TD]
[TD]14/11/2016[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]14/11/2016[/TD]
[TD]GENERAL ENQUIRY[/TD]
[TD]Complete [/TD]
[TD]15/11/2016[/TD]
[/TR]
[TR]
[TD]Direct email to CC [/TD]
[TD]14/11/2016[/TD]
[TD]QUOTE REQUST[/TD]
[TD]In progress[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Direct email to CC [/TD]
[TD]15/11/2016[/TD]
[TD]COMPLAINT[/TD]
[TD]In progress[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Direct email to CC [/TD]
[TD]15/11/2016[/TD]
[TD]SPEC REQUEST[/TD]
[TD]With Dean H[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Online enquiry [/TD]
[TD]16/11/2016[/TD]
[TD]QUOTE REQUST[/TD]
[TD]Complete [/TD]
[TD]16/11/2016[/TD]
[/TR]
[TR]
[TD]Ralf[/TD]
[TD]16/11/2016[/TD]
[TD]SPEC REQUEST[/TD]
[TD]Complete [/TD]
[TD]17/11/2016[/TD]
[/TR]
[TR]
[TD]Marc[/TD]
[TD]16/11/2016[/TD]
[TD]SAMPLE REQUEST[/TD]
[TD]In progress[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Direct email to CC [/TD]
[TD]16/11/2016[/TD]
[TD]COMPLAINT[/TD]
[TD]With Quality[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Direct email to CC [/TD]
[TD]17/11/2016[/TD]
[TD]GENERAL ENQUIRY[/TD]
[TD]Complete [/TD]
[TD][/TD]
[/TR]
</tbody><colgroup><col><col><col><col><col></colgroup>[/TABLE]

 

[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"