Deleting rows with no data using Auto Filter and Helper column

J

John

I want my spreadsheet to print only those rows which
contain data in Column O if Column O is greater than the
value of zero. I have header data in A6:Q7 for each of
the columns A through O. My entire spreadsheet (not
counting the header rows) is A9:Q200. How do I get my
spreadsheet to print only those rows which contain data
in Column O that is greater than the value of zero?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sectioning rows of text based on value of associated data column 1
auto filter on columns 2
SUMPRODUCT calculating difference between column values 8
sort only rows with data 7
SumIf AND 6
Hidden Rows with Auto-Filter 2
Unique records formula & zero entries 9
remove duplicate rows from specific data in a column; excel 2007 1

Top