Filtering Out entire row if all columns of values have all zeros

yankeegooner

New Member
Joined
Jul 15, 2014
Messages
1
I have searched the many threads of this forum that have similar questions, but I have not found what I really need.

I have a sheet that pulls values from another sheet based on user selections. For the years selected, say 2014 to 2050 (37 columns), if all of the columns for that entry (Product description, which is the left-most column) is zero, how can I filter out the entire row (37 columns + product column) and not show it to the user?

I have tried unsuccessfully to use the advanced filter.

Thanks for your help!
 

Forum statistics

Threads
1,086,122
Messages
5,387,975
Members
402,092
Latest member
S_S

Some videos you may like

This Week's Hot Topics

Top