Pivot Table Question

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

Guest

I have 21k rows of data and I would like to only pull out those rows of data
that are less than 0 in one of the columns. I thought a pivot table would do
it best, but I'm not sure how to set-up the formula to pull out the data? Is
there a better way?
 
Data>Autofilter. Then choose the column where you want to do the filtering.
Choose "Custom" to set your criteria to "is less than" 0.
 
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 Comparison 1
Pivot Table with Data Model Connection - getpivotdata reference issue 0
Pivot Tables by Macro 2
Pre-configuring Pivot table "views" 4
Pivot tables, IF statements, vlookups? 2
Can a pivot table be redirected to an external source? 1
Workbook pivot table design function 6
Unable to Group in Pivot Table 1

Back
Top