Create a new list of all data in row if cell F = Yes

[wagmanm]

	A	B	C	D	E	F
1	Round	36	36	3.53	Front	No
2	Round	24	24	1.57	Left	Yes
3	Round	32	32	2.23	Left	No
4

<tbody>
</tbody>

I would like to create a new list starting in row 10 that only lists all data from the rows (searching through rows 1 to 9), if cell F in that row = Yes?
I believe this would be an array formula but I cant seem to find anything that will work. Can anyone help me with this?

Thanks,
Mark

 

[Joe4]

Why not just use Advanced Filters, where you can filter the results to a new location?
See: http://www.contextures.com/xladvfilter01.html