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!
Bookmarks