Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Need formula or report to condense table, not by manual sort
I am trying to find a formula or other way (other than manually sort) to
select from the table below, just the list of items that have a quantity. Basically create a table in another sheet using the data below but €ścondensed€ť without adding the items that have no quantity values. The table is lengthy and I want to create a formula or report. I know sorting would give me the view I need want a formula to do automatically and not show any items that are €śzero€ť. Thanks. A B 1 Item description Item Qty 2 AirConditioner Large 3 AirConditioner Small 4 Baby Carriage 1 5 Baby Crib 6 Base Buffet 2 7 Bathinette 8 BBQ Grill Large 9 BBQ Grill Small 1 10 Bed, Bunk (Set of 2) 11 Bed, King 12 Bed, Queen 1 13 Bed, Rollaway 14 Bed, Single/Hollywood 15 Bed, Standard Double 16 Bed, Waterbed Base 17 Bed, Youth 18 Bicycle Desired result: 1 Baby Carriage 2 Base Buffet 1 BBQ Grill Small 1 Bed, Queen |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Pivot Table - Sort Report Filter Values | Excel Discussion (Misc queries) | |||
How do I Use the MANUAL Sort Option in a Pivot Table? | Excel Discussion (Misc queries) | |||
Pivot table aging report sort order | Excel Worksheet Functions | |||
How do I change a pivot table report to sort when I drill down | Excel Worksheet Functions | |||
Condense formula | Excel Worksheet Functions |