Re: Index/Match Help

From: Ben (anonymous_at_discussions.microsoft.com)
Date: 12/01/04 

Date: Wed, 1 Dec 2004 05:49:31 -0800

I'm not sure I understand... maybe this helps:

SALES - total area of data, including date, customer, etc.
SALE_DATE - list of dates, may have skipped/blank rows
O4 - Cell w/ "DATE", "Customer" etc
O13:T13 - List titles including "DATE", "CUSTOMER" etc

SALE_DATE never exceeds today() but may equal it.
Numerous entries may have the same date. Entry to entry
may skip numerous days, ie O14=11/11/04 and O15=12/1/04.

Is this better?

Thanks

>-----Original Message-----
>You have not said what is in the various ranges
referenced by your
>formula. Assuming that you have a range of sale dates,
=MAX(dateRange)
>is the date of the most recent sale and =LARGE
(dateRange,2) is the date
>of the second most recent sale.
>
>Jerry
>
>Ben wrote:
>
>> I have the following formula to extract the date of the
>> most recent sale from a list.
>>
>> =INDEX(SALES,MATCH(TODAY(),SALE_DATE,1),MATCH
>> (O4,O13:T13,0))
>>
>> I would like to build another formula to extract the
next
>> recent sales date entry. This entry may have the same
>> date as the most recent in the list. I have tried
>> entering -1 in various places, only to retrive errors
or
>> yesterdays date with no data (in the case there was no
>> sale yesterday).
>>
>> Does anyone have any ideas?
>>
>> Thank you.
>
>.
>