Re: Index/Match Help

From: Jerry W. Lewis (post_a_reply_at_no_e-mail.com)
Date: 12/01/04 

Date: Wed, 01 Dec 2004 13:29:06 GMT

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.

Loading