Pivot Table Question

D

dallin

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?
 
S

Shatin

Data>Autofilter. Then choose the column where you want to do the filtering.
Choose "Custom" to set your criteria to "is less than" 0.
 
Top