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

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" wrote in message
...
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: =(M2N2)

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!