Advanced filter
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)
|