Thread: Getting the "0" out of an auto populate cell.
View Single Post
  #10   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Glenn Glenn is offline
external usenet poster
  
Posts: 1,240
Default Getting the "0" out of an auto populate cell.
Bill638 wrote:
Thanks Glenn,

I've uploaded it. The project URL is
http://www.savefile.com/projects/808763180 and the link to the file is
http://www.savefile.com/files/2093305. Note that the report worksheet also
has a cover page, overview, etc., that I don't want affected by the filter.

I greatly appreciate your assistance.

Just select "NonBlanks" from the first drop down list. It should be the last entry.
Reply With QuoteReply With Quote