How can I check/verify data in my Data Source for Pivot table?

G

gayleh

When I sort my data source on a different column (example column A) I get
one result, and if I go sort on another column (example column F) and refresh
data I get different results- when I havent changed any data - only the
sorting. I found one other time I had mixed data in a column (most entries
dated March or April, but one had 4/2009). I have been checking for similar
problem....but have not found any obvious errors.
Question is - is there an easy way I can do some sort of Check on my
data?????? to pinpoint issues? Thanks!
 

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

Showing data unigue to multiple columns in a pivot table 1
Pivot table data source 1
How to clear data in pivot table? 4
All data in my worksheet was lost how do I retrieve it 1
Lookup data in a variable table & retrieve data from a pivot table 3
Pivot table: How do I make a monthly breakdown of daily data? 6
How can I use a pivot table as source for a second table? 2
Challenging Formula Issue 1

Top