[TABLE="width: 500"]
<tbody>[TR]
[TD="align: center"]A
[/TD]
[TD="align: center"]B
[/TD]
[TD="align: center"]C
[/TD]
[TD="align: center"]D
[/TD]
[TD="align: center"]E
[/TD]
[TD="align: center"]F
[/TD]
[TD="align: center"]G
[/TD]
[TD="align: center"]H
[/TD]
[TD="align: center"]I
[/TD]
[/TR]
[TR]
[TD]Line
[/TD]
[TD]Quantity
[/TD]
[TD]Description
[/TD]
[TD]Price
[/TD]
[TD]Extension
[/TD]
[TD]Tax Rate
[/TD]
[TD]Tax AMT
[/TD]
[TD]Type
[/TD]
[TD]Total
[/TD]
[/TR]
[TR]
[TD]1
[/TD]
[TD]25
[/TD]
[TD]descript 1
[/TD]
[TD]5.00
[/TD]
[TD]125.00
[/TD]
[TD].0825
[/TD]
[TD]10.31
[/TD]
[TD]Composite
[/TD]
[TD]135.31
[/TD]
[/TR]
[TR]
[TD]2
[/TD]
[TD]150
[/TD]
[TD]descript 2
[/TD]
[TD]10.00
[/TD]
[TD]1500.00
[/TD]
[TD].0825
[/TD]
[TD]123.75
[/TD]
[TD]Non-Composite
[/TD]
[TD]1623.75
[/TD]
[/TR]
</tbody>[/TABLE]
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
<tbody>[TR]
[TD="align: center"]A
[/TD]
[TD="align: center"]B
[/TD]
[TD="align: center"]C
[/TD]
[TD="align: center"]D
[/TD]
[TD="align: center"]E
[/TD]
[TD="align: center"]F
[/TD]
[TD="align: center"]G
[/TD]
[TD="align: center"]H
[/TD]
[TD="align: center"]I
[/TD]
[/TR]
[TR]
[TD]Line
[/TD]
[TD]Quantity
[/TD]
[TD]Description
[/TD]
[TD]Price
[/TD]
[TD]Extension
[/TD]
[TD]Tax Rate
[/TD]
[TD]Tax AMT
[/TD]
[TD]Type
[/TD]
[TD]Total
[/TD]
[/TR]
[TR]
[TD]1
[/TD]
[TD]25
[/TD]
[TD]descript 1
[/TD]
[TD]5.00
[/TD]
[TD]125.00
[/TD]
[TD].0825
[/TD]
[TD]10.31
[/TD]
[TD]Composite
[/TD]
[TD]135.31
[/TD]
[/TR]
[TR]
[TD]2
[/TD]
[TD]150
[/TD]
[TD]descript 2
[/TD]
[TD]10.00
[/TD]
[TD]1500.00
[/TD]
[TD].0825
[/TD]
[TD]123.75
[/TD]
[TD]Non-Composite
[/TD]
[TD]1623.75
[/TD]
[/TR]
</tbody>[/TABLE]
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