Pivot Table Question
 

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?
--
thanks, mc

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

"dallin" wrote in message
...
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?
--
thanks, mc