excelbeginner3
New Member
- Joined
- Nov 17, 2016
- Messages
- 3
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!
<tbody>
</tbody><colgroup><col><col><col><col><col></colgroup>
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>