Pull data if conditions met

[hedgie]

I am trying to create a worksheet that pulls data from another sheet. I want rows from the original sheet excluded if they do not meet certain criteria. WHat is the correct formula to use to pull this conditionally?

 

[sprigelz]

Try this

=FILTER(Sheet1!A:D,(Sheet1!C:C="M")*(Sheet1!B:B>=30))

 

[Fluff]

How about

=FILTER(A3:D6,(B3:B6>30)*(C3:C6="M"))

 

[hedgie]

Fantastic - is it possible to not copy the entire row and just certain columns?

 

[Fluff]

Which columns?

 

[hedgie]

In this example let me just pull name and amount. In my real sheet there are actually many columns so I want to pull a handful.

 

[Fluff]

How about

Fluff.xlsm
	A	B	C	D	E	F	G	H
1	Name	Age	Sex	Amount			Name	Amount
2	a	27	M	100			b	200
3	b	36	M	200			d	400
4	c	25	F	300
5	d	42	M	400
6	e	39	F	500
Main

Cell Formulas
Range	Formula
G2:H3	G2	=FILTER(FILTER(A2:D6,(B2:B6>30)*(C2:C6="M")),ISNUMBER(MATCH(A1:D1,G1:H1,0)))
Dynamic array formulas.