Return all rows that match condition

bryanhope

New Member
Joined
Mar 22, 2017
Messages
4
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
 

Some videos you may like

Excel Facts

Can Excel fill bagel flavors?
You can teach Excel a new custom list. Type the list in cells, File, Options, Advanced, Edit Custom Lists, Import, OK

Joe4

MrExcel MVP, Junior Admin
Joined
Aug 1, 2002
Messages
54,135
Office Version
365
Platform
Windows
How about just using Filters?
Just click on the Filter button, select the drop-down on the Type header, and select the "Composite" option.
 

Subscribe on YouTube

Watch MrExcel Video

Forum statistics

Threads
1,106,317
Messages
5,510,558
Members
408,799
Latest member
msann

This Week's Hot Topics

  • Turn fraction around
    Hello I need to turn a fraction around, for example I have 1/3 but I need to present as 3/1
  • TIme Clock record reformatting to ???
    Hello All, I'd like some help formatting this (Tbl-A)(Loaded via Power Query) [ATTACH type="full" width="511px" alt="PQdata.png"]22252[/ATTACH]...
  • TextBox Match
    hi, I am having a few issues with my code below, what I need it to do is when they enter a value in textbox8 (QTY) either 1,2 or 3 the 3 textboxes...
  • Using Large function based on Multiple Criteria
    Hello, I can't seem to get a Large formula to work based on two criteria's. I can easily get a oldest value based one value, but I'm struggling...
  • Can you check my code please
    Hi, Im going round in circles with a Compil Error End With Without With Here is the code [CODE=rich] Private Sub...
  • Combining 2 pivot tables into 1 chart
    Hello everyone, My question sounds simple but I do not know the answer. I have 2 pivot tables and 2 charts that go with this. However I want to...
Top