Thanks Troy,

That works perfectly.
Once again I have been saved by the vast knowledge residing in this
news group.
Many thanks to yourself, Tom, and Debra.

Till next crisis
Zoop.

In article , TroyW
wrote:

Zoop,

I thought you wanted the "prefix" version. This version will match
absolutely. Note the following changes to my previous post.

D1: The column name MUST now match the column name in the Data Table, cell
D10.
D2: The formula has changed to: ="="&""&$B$3&""
(those are all double-quotes, no single-quotes)

Troy

==== Updated Version Below ====
Create a worksheet with the cells set up as follows:

A1: FilterDateBeg
A2: FilterDateEnd
A3: FilterCode
B1: 09/01/2003
B2: 09/30/2003
B3: 09110-

D1: CodeNum
D2: ="="&""&$B$3&""
E1: DummyDate
E2: =AND(C11=$B$1,C11<=$B$2)

C10: RentalDate
C11: 08/27/2003
C12: 08/30/2003
C13: 09/14/2003
C14: 09/23/2003
C15: 09/25/2003
C16: 10/01/2003

D10: CodeNum
D11: 09110-01
D12: 09110-
D13: 09110-
D14: 09123-99
D15: 09110-
D16: 09110-10


"Zoop" wrote in message
...
Thanks Troy,

That works great for the dates excellent, but I need to differentiate
between codes like '09110-' and '09110-10', your technique filters
anything with with'09110-' as a prefix.

Thanks For your help
Zoop

In article , TroyW
wrote:

=AND(C11=$B$1,C11<=$B$2)