Filtering question

[GerryK]

Hi,
How best can I display all rows of information that meet a
criteria found within a range? I'm trying to use Custom
filter and/or Advanced filter for this but have not found
the solution.

My situation is that the continuous adjacent columns range
G210,035 within A1:U10,035 contain numbers only and I
would like to see only those rows that have numbers
greater than 29 anywhere within the range. (Row 1 is a
header row with text labels)

Any ideas greatly appreciated.

TIA

 

[Frank Kabel]

Hi
see:
http://www.contextures.com/xlautofilter01.html
and
http://www.contextures.com/xladvfilter01.html

Another way: in column V (a helper column) enter the following formula
in P2
=IF(COUNTIF(G22,">29"),1,0)
copy this for all rows and use this column for filtering