Query table in excel, filter by date
Posted on 2014-01-18
I have a table of projects in Excel. There is a column for Project Name and and column for End Date. I would like a query in a separate worksheet that returns a column of data containing only those Project Names that end prior to a date I enter into a cell in Excel. Suggestions for best way?
Pivot Table - does not have filter for less than arbitrary date.
Control Array - returns only filtered projects but leaves blank lines where projects do not match criteria. I do not want blank lines.
VBA code - yes, I could build my own filter easily enough, but prefer existing tools if possible. This may end up as best solution.
query builder - not friendly to finding tables in existing workbook. I would like to be proven wrong about this.