Retrieving from a list only those rows with data

HSA

New Member
Joined
Apr 3, 2002
Messages
8
I have a list in Excel. I want to produce a report which only contains the rows which contain data greater than 0. There are several columns. Below is an example and in the create another list with only those rows with Gross Sales more than 0 in another worksheet. There are in fact more rows and columns than this.
Enterprise Gross Sales
Jumpers $500,000
Skirts $650,000
Jeans $0
Shoes $0
Stockings $0
Gloves $0
Hats $0
Underwear $50,000
Thank you in anticipation.
 

Excel Facts

How to fill five years of quarters?
Type 1Q-2023 in a cell. Grab the fill handle and drag down or right. After 4Q-2023, Excel will jump to 1Q-2024. Dash can be any character.
why dont you insert a customa auto filter above your range.


click the cell above your range of $ values. then goto insert/autofilter. click on the filter and chose custom. then make it >0
 
Upvote 0

Forum statistics

Threads
1,215,327
Messages
6,124,292
Members
449,149
Latest member
mwdbActuary

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top