If functions
 

This is what I'm trying to do:

In column E I have a number ($ - and can be negative or positive numbers)
and in column F I have a percentage. I want to extract all informational
data on columns A through F in which column E is either greater or less than
+/- $3700 OR in which column F is greater than +/- 20%.

Essentially, the results would then NOT include anything under +/- $3700 AND
also under 20%.

Thanks.

If functions
 

what do mean by extract?
if just show
in G1
enter
=if(or(abs(E1)3700,abs(F1).2),1,"")
copy down to end of data
use auto filter on Column G and select "*"
"LAndersen" wrote:

This is what I'm trying to do:

In column E I have a number ($ - and can be negative or positive numbers)
and in column F I have a percentage. I want to extract all informational
data on columns A through F in which column E is either greater or less than
+/- $3700 OR in which column F is greater than +/- 20%.

Essentially, the results would then NOT include anything under +/- $3700 AND
also under 20%.

Thanks.

If functions
 

Checkout AutoFIlter:
Data Filter AutoFilter Custom

you can set up two criteria on the dollar amount and one criterium on the
percentage.

The filter will display only rows meeting all three cirteria.


--
Gary's Student
gsnu200707


"LAndersen" wrote:

This is what I'm trying to do:

In column E I have a number ($ - and can be negative or positive numbers)
and in column F I have a percentage. I want to extract all informational
data on columns A through F in which column E is either greater or less than
+/- $3700 OR in which column F is greater than +/- 20%.

Essentially, the results would then NOT include anything under +/- $3700 AND
also under 20%.

Thanks.

If functions
 

You are awesome!!! Thank you! That is one feature of Excel I'm horrible
about remembering - I always want to put in a formula!

Now...here is my next question...once I have all the data filtered - can I
copy and paste that data into another workbook without also pasting the
hidden rows?

Thanks!

"Gary''s Student" wrote:

Checkout AutoFIlter:
Data Filter AutoFilter Custom

you can set up two criteria on the dollar amount and one criterium on the
percentage.

The filter will display only rows meeting all three cirteria.


--
Gary's Student
gsnu200707


"LAndersen" wrote:

This is what I'm trying to do:

In column E I have a number ($ - and can be negative or positive numbers)
and in column F I have a percentage. I want to extract all informational
data on columns A through F in which column E is either greater or less than
+/- $3700 OR in which column F is greater than +/- 20%.

Essentially, the results would then NOT include anything under +/- $3700 AND
also under 20%.

Thanks.

If functions
 

That looks promising. I've never used the vlookup formula, what do the 2,0
and 3.0 represent.
--
Cheers,


"Gary''s Student" wrote:

Yes!! The great thing about filters in general is that you can copy/paste
only what you see.

I strongly suggest that you play around with them for a while. Its worth
the time.
--
Gary''s Student
gsnu200707


"LAndersen" wrote:

You are awesome!!! Thank you! That is one feature of Excel I'm horrible
about remembering - I always want to put in a formula!

Now...here is my next question...once I have all the data filtered - can I
copy and paste that data into another workbook without also pasting the
hidden rows?

Thanks!

"Gary''s Student" wrote:

Checkout AutoFIlter:
Data Filter AutoFilter Custom

you can set up two criteria on the dollar amount and one criterium on the
percentage.

The filter will display only rows meeting all three cirteria.


--
Gary's Student
gsnu200707


"LAndersen" wrote:

This is what I'm trying to do:

In column E I have a number ($ - and can be negative or positive numbers)
and in column F I have a percentage. I want to extract all informational
data on columns A through F in which column E is either greater or less than
+/- $3700 OR in which column F is greater than +/- 20%.

Essentially, the results would then NOT include anything under +/- $3700 AND
also under 20%.

Thanks.