VSTACK Assistance

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

Try this,

Please Login or Register  to view this content.

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