Extract Data from a Table in Excel Based On A Criteria

Question

I have a list of data in 'Table1' on an Excel spreadsheet that looks like this:

Column A       Column B
Pizza Sauce    3
Pepperoni      0
Cheese         1
Crust          2
Garlic         0
Sausage        0

From this list I want to be able to create a second list that, based on the value in B, shows the value in A. I want anything that is greater than 0 to show in this list (For an order sheet to give to a vendor). Like such:

Column A       Column B
Pizza Sauce    3
Cheese         1
Crust          2

How might I go about doing this? I've looked around but haven't been able to do so successfully.

crazyfrog · Accepted Answer · 2015-03-09 10:33:35Z

0

Why don't you use pivot table and filter out 0 value in column B. So every time you want an updated table, you just have to refresh the pivot table and your table is ready.

You can find pivot option in Insert -> PivotTable and provide the source data.

answered Mar 9, 2015 at 10:33

crazyfrog

951 gold badge3 silver badges9 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Extract Data from a Table in Excel Based On A Criteria

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related