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

S

SteveC

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

Ron Coderre

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
 
P

Peo Sjoblom

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

Peo


Ron Coderre said:
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 said:
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!
Click to expand...
Click to expand...
 
Top