I have a sheet, where it points to another sheet. The formula under the heading tracking number is IF(DropIn!G2="","",DropIn!G2). The problem is when I pivot, I am getting a count of all cells where the formula is not just tracking number. I know I can change the pivot each time to remove the blanks under row labels, however, I just want the user to refresh the pivot each time he updates the spreadsheet, without have to uncheck that. Is there a way to have the pivot only work on cells that have data as opposed to "". Thank You
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
