Hi Chris, could concatenate the two values in another column and then filter on that column. That is, if your two data points are in cell A1 and B1 and your data table ends at column F, you could put the following formula in column G.
=A1&B1
Then you filter on column G.
Hope this helps you out.
Barrie
Chris, it sounds like you want to filter your data
based on an OR condition (e.g., column A = {"X";"Y"}
OR column B = {1,2}) such that the records,
{"X",3;"Z",1;"Y",1} would be displayed.
This is supported using an Advanced AutoFilter
whereby you'd setup a Criteria using the field
names for column A ("Field1") and column B ("Field2").
It would look like...
{"Field1","Field2"
;"X",
;"Y",
;,1
;,3}
When setting up an Excel Criteria remember that
AND-ing s accomplished with the addition of
columns and OR-ing is accomplished with the
addition of rows. The Excel Help Topic for
"Examples of advanced criteria" does an
exellent job of explaining this.
If I have understood you correctly you will not be able to do this with Excels Auofilter. This is because it hides the entire row and not just the cell.
You could place the data in Column B underneath the data in Column A.
Or go to Window>New Window and filter them in seperate Widows.
Dave
OzGrid Business Applications
Chris, trust me... directly above do the trick! : )