Yes it is just sample info. I meant to have the end date of record 003 to be
a day before the start date of record 002. Sorry about that.

sali wrote:
is this exact example of data, or just info?
because, your example of 10/28/2005 has *two* matches, record #003 and
record#002.

are you looking for macro or formula solution?

I need help trying to pull information within a start date and end date. The
order date should be between the start and end date and then pull the correct
[quoted text clipped - 13 lines]
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200704/1

--
Message posted via http://www.officekb.com