Selecting Oldest Date From List

**dcaraher** · 08-31-2010, 06:32 AM

I have what I think is a simple problem, but I'm struggling with a solution.

I have attached a very simple example of what I am trying to do. I have a very large list of suppliers which shows amongst a lot of other data the invoice date.

I would like to extract a list of suppliers that have not invoiced me in the last 6 months. In my example I would expect to see supplier C only.

Many Thanks in anticipation of your help.

**t0m46** · 08-31-2010, 07:11 AM

Hey,

A Really simple way would be to apply a filter on the date to be greater data than 6 months ago, this would show all the invoices and you could print, copy, do what you want with them.

**dcaraher** · 08-31-2010, 07:22 AM

Thanks for the response, what I am looking for is not a list of invoices over 6 months old but who has not invoiced me in the last 6 months.

In my example it is only supplier C.

**estige** · 08-31-2010, 07:28 AM

One way is to make a helper column to identify suppliers:

Please Login or Register  to view this content.

The result can be displayed with filtering, or to just get one listing of every supplier, a pivot (see attachment)

**dcaraher** · 08-31-2010, 08:36 AM

Estige,

Thanks for the response, it should be exactly what I'm looking for, however when I apply the formulae as an array (CSE) then I get a number error.

I have attached a shortened version of the actual worksheet, Test2, if that is of any use.

**estige** · 08-31-2010, 09:08 AM

Everything looks fine when I open it (both in excel 2003 and 2010)

Edited:
Sorry, I had saved in 2003-format from 2010 before I opened it in 2003.
Now I see the problem in Excel 2003.
I'll come back to you..