VSTACK Assistance

[babylock99]

HI all,

Can I ask a favour

I have a sheet where if certain criteria is met, to vstack the relating results

If Animal = Dog, return Variance 1, Variance 2 in a list only

[windknife]

Try this,

=FILTER(A:B,C:C="Dog")

[josephteh]

Maybe, =TOCOL(FILTER(A2:B12,C2:C12="Dog"),1,TRUE)