+ Reply to Thread
Results 1 to 2 of 2

Values in a specified category need only show up when a specified value>zero?

  1. #1
    Registered User
    Join Date
    04-03-2014
    Location
    Houston, Texas
    MS-Off Ver
    Excel 2010
    Posts
    1

    Values in a specified category need only show up when a specified value>zero?

    I am creating a spreadsheet that allocates hours to different categories of work - for example, "Fire Protection". I need the allocated hours for all of the different Fire Protection duties to only show up when a value greater than zero is entered in the column at the top of this category entitled "Fire Protection". If "Fire Protection" has a value of zero, then all fire protection-related duties will automatically be zero as well - in effect, this category of hours is nullified.

    I hope that is a clear explanation, because I have no idea how to accomplish this!

  2. #2
    Forum Expert newdoverman's Avatar
    Join Date
    02-07-2013
    Location
    Port Dover, Ontario, Canada
    MS-Off Ver
    2010
    Posts
    10,330

    Re: Values in a specified category need only show up when a specified value>zero?

    Attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are demonstrated, mock them up manually if needed. Remember to desensitize the data.

    Click on GO ADVANCED and use the paperclip icon to open the upload window.

    View Pic
    <---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.
    Ron W

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] VBA to show Horizontal Category axes in Charts
    By caabdul in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-26-2014, 02:10 PM
  2. How to Chart values for Division vs Category and Sub-Category?
    By rahulgk in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 06-11-2013, 06:33 AM
  3. Replies: 9
    Last Post: 04-27-2011, 09:12 PM
  4. Show Specific Category by day and how many times
    By apollopt in forum Excel General
    Replies: 4
    Last Post: 03-23-2010, 04:46 AM
  5. Accounting Category Display does not show the correct format/outpu
    By per-ardua-ad-astra in forum Excel - New Users/Basics
    Replies: 5
    Last Post: 01-07-2006, 09:35 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1