Advanced Filter for Values in Column M greater than Values in Colu

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: =(M2>N2)

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

Select your list (M1:N100)

<Data><Filter><Advanced Filter>
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-Pro


"SteveC" wrote:

> 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!

It does, thanks very much!

You can leave A1 blank if you use a formula as criteria

Peo


"Ron Coderre" <ronSKIPTHIScoderre@bigfoot.com> wrote in message
news:9FBC88F8-93BE-4D88-B8BE-3350F56A1853@microsoft.com...
> 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: =(M2>N2)
>
> Note: that criteria refers to the 1st data row under the titles.
>
> Select your list (M1:N100)
>
> <Data><Filter><Advanced Filter>
> 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-Pro
>
>
> "SteveC" wrote:
>
>> 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!