Autofilter and regression

[agbiggs]

I've been trying to do a regression analysis on data I've filtered
using autofilter. I keep getting the error message "input range
contains non-numeric data." I've used autofilter to eliminate any non-
numeric cells and I've also made sure it's formatted as a number
(through the general formatting, and also by doing a paste-special
where I multiply every cell by 1). I can't seem to get rid of this
error message, though. Is it possible that these non-numeric cells
aren't being filtered out as far as the regression is concerned? Any
help appreciated!

 

[Bernie Deitrick]

Some functions respond to filtering, and others don't - I would copy the filtered data elsewhere (or
use formulas that extract just the filtered data) and run the regression on that table rather than
the filtered data.

HTH,
Bernie
MS Excel MVP