software

How do I set this up?

I know how to set up Advanced Filter for a set value, but how do I set it up
for a relative value?

That is this:
Col M Col N
5 6
7 4
4 2
5 6

Becomes this:
7 4
4 2

Thanks very much!

Try this:

With your list is in M1:N100, with titles in row 1
For example
M1: MyCol_M
N1: MyCol_N

A1: MyTest (or any text that is not a column title)
A2: =(M2gt;N2)

Note: that criteria refers to the 1st data row under the titles.

Select your list (M1:N100)

lt;Datagt;lt;Filtergt;lt;Advanced Filtergt;
List Range: (already selected $M$1:$N$100)
Criteria Range: $a$1:$a$2

Click the [OK] button to filter the list in place.

Does that help?
***********
Regards,
Ron

XL2002, WinXP-Proquot;SteveCquot; wrote:

gt; How do I set this up?
gt;
gt; I know how to set up Advanced Filter for a set value, but how do I set it up
gt; for a relative value?
gt;
gt; That is this:
gt; Col M Col N
gt; 5 6
gt; 7 4
gt; 4 2
gt; 5 6
gt;
gt; Becomes this:
gt; 7 4
gt; 4 2
gt;
gt; Thanks very much!

It does, thanks very much!You can leave A1 blank if you use a formula as criteria

Peoquot;Ron Coderrequot; gt; wrote in message
...
gt; Try this:
gt;
gt; With your list is in M1:N100, with titles in row 1
gt; For example
gt; M1: MyCol_M
gt; N1: MyCol_N
gt;
gt; A1: MyTest (or any text that is not a column title)
gt; A2: =(M2gt;N2)
gt;
gt; Note: that criteria refers to the 1st data row under the titles.
gt;
gt; Select your list (M1:N100)
gt;
gt; lt;Datagt;lt;Filtergt;lt;Advanced Filtergt;
gt; List Range: (already selected $M$1:$N$100)
gt; Criteria Range: $a$1:$a$2
gt;
gt; Click the [OK] button to filter the list in place.
gt;
gt; Does that help?
gt; ***********
gt; Regards,
gt; Ron
gt;
gt; XL2002, WinXP-Pro
gt;
gt;
gt; quot;SteveCquot; wrote:
gt;
gt;gt; How do I set this up?
gt;gt;
gt;gt; I know how to set up Advanced Filter for a set value, but how do I set it
gt;gt; up
gt;gt; for a relative value?
gt;gt;
gt;gt; That is this:
gt;gt; Col M Col N
gt;gt; 5 6
gt;gt; 7 4
gt;gt; 4 2
gt;gt; 5 6
gt;gt;
gt;gt; Becomes this:
gt;gt; 7 4
gt;gt; 4 2
gt;gt;
gt;gt; Thanks very much!