Extract all records that match criteria in 2 columns

Hi

Would you please help me write the formula to extract all records that match "1" in E and are >0 in J?

Thanks

Here is the file requested.

Would you please modify if the first criterion (match 1) would be stored in say L1 and the 2nd (0) stored in L2.

In other words, extract all records that in column E match L1 and in column J are greater than L2

Thanks

Alternatively you could use filters - please see attached.

Would this work for you?

Regards

peterrc

I am aware of the filter solution.
I am trying to learn /see the logic in the formula.

In order to better understand the formula could you please modify as requested above?
i.e.: extract all records that in column E match L1 and in column J are greater than L2

I appreciate it.

Originally Posted by Richard Buttrey

I don't understand. Column L doesn't contain any data.

you are right.

I requested that be made believed that the conditions in post 1 are in L1,L2 like the file in post 11.

@nflsales

For argument sake, in copying the formula to right in Book2 (1).xls‎, I wonder why V3=0 while W3=""

Originally Posted by Richard Buttrey

The

Formula:

Please Login or Register  to view this content.

...When copied to the next column the range is M$1:N1 ...

When copied to the next column is N$1:N1 not M$1:N1.
Regardless, changing the ROWS(M$1:M1) with 1 in the formula and then copying to right, does not seem to change results.

That is why I need to understand this step by step so I can recreate it when needed instead of just pasting in this instance and ask again in another instance.