Ignoring Lines with Errors in Pivot Tables

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is there a way to ignore the lines that have errors, i.e. "#Value" and "####"
when I create my pivot tables?
 
Maybe you can use another column for your pivottable:

=if(iserror(b99),0,b99)

and use that in your PT.

What caused the ###'s?
 
The time went past midnight and so it is not being recognized. There are two
sets of time and dates with all of them in separate cells.
 
I'm not sure what you want to do when your time goes past midnight, but if it's
based on subtracting two times, you can do things like:

=(A1-B1)+(B1>A1)
which is shorthand for:
=(A1-B1)+IF(B1>A1,1,0)

If you really are subtracting times, it might be a good idea to include both the
time and date in those cells. Then you don't have to worry about going across 2
midnights.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pivot Table with Data Model Connection - getpivotdata reference issue 0
Average of Subtotals in Pivot Table 0
N/A in pivot table become 0 1
Access #Error & Excel Pivot 0
Pre-configuring Pivot table "views" 4
Excel 2007 Pivot Tables compatible with 2003 3
Excel VBA For excel 0
Size of file with pivot table 2

Back
Top