Return all rows that match condition

[bryanhope]

A	B	C	D	E	F	G	H	I
Line	Quantity	Description	Price	Extension	Tax Rate	Tax AMT	Type	Total
1	25	descript 1	5.00	125.00	.0825	10.31	Composite	135.31
2	150	descript 2	10.00	1500.00	.0825	123.75	Non-Composite	1623.75

<tbody>
</tbody>

Hello, I have a table like this with thousands of rows I am trying to find a formula that will return all rows that match "Composite" of the Type column, I know there are multiple ways but I am having problems any help would be great. Thanks

 

[Joe4]

How about just using Filters?
Just click on the Filter button, select the drop-down on the Type header, and select the "Composite" option.