filtering based on a value in a cell
 

Dear All,

I would like to be able to filter a series of values based on the
contents of a cell.
Typically, the values would be integers and if a particular cell shows
an integer, a set of rows are filtered accordingly.


Thanks in advance


John Fox

filtering based on a value in a cell
 

Assuming the values are in a table, you can use an Advanced Filter, as
described he

http://www.contextures.com/xladvfilter01.html

Or add a column to the table, and compare the row contents to the target
value. Then, use an AutoFilter and filter that column for true or false.


John E. Fox wrote:
Dear All,

I would like to be able to filter a series of values based on the
contents of a cell.
Typically, the values would be integers and if a particular cell shows
an integer, a set of rows are filtered accordingly.


Thanks in advance


John Fox


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html