+ Reply to Thread
Results 1 to 2 of 2

Excel Rule Help

  1. #1
    Registered User
    Join Date
    12-01-2011
    Location
    Washing, DC
    MS-Off Ver
    Excel 2003
    Posts
    1

    Excel Rule Help

    I'm currently pulled data into a pivot table. I have an =if(or rule currently set up but the issue I am having is that there are less row cells for one of my filters. This is causing the rule I have set up to input verbiage into blank cells for my one filter. For instance, my rule states that if a cells value is over 100 "Not in Top 100" will appear for the cells down to row 76. For one filter there's only data for cells up to 49, but "Not in the Top 100" is still appearing.

    How can I add an additional rule stating something like in a cell is blank ignore the rule and leave the cell blank?

    Thanks for your help!

  2. #2
    Forum Contributor arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,166

    Re: Excel Rule Help

    As long as you do not have any other conditions for the false part of the "Not in the Top 100", you can use this -
    Please Login or Register  to view this content.
    If I have helped, Don't forget to add to my reputation (click on the star below the post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
    Use code tags when posting your VBA code: [code] Your code here [/code]

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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