If functions

[Guest]

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.

 

[Guest]

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 "*"

 

[Guest]

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.

 

[Guest]

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!

 

[Guest]

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.

 

[Guest]

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