Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / New Users / November 2007

Tip: Looking for answers? Try searching our database.

Autofilter and regression

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
agbiggs@hotmail.com - 08 Nov 2007 15:48 GMT
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 - 09 Nov 2007 14:16 GMT
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

> I've been trying to do a regression analysis on data I've filtered
> using autofilter. I keep getting the error message "input range
[quoted text clipped - 5 lines]
> aren't being filtered out as far as the regression is concerned? Any
> help appreciated!
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.