Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I ingnore non-numeric cells in Analysis toolpak?
When using the Correlation Function in the analysis toolpak, I get an error
message if my dataset contains non-numeric fields. Is there a way to get Excel to ignore fields that are non-numeric? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I ingnore non-numeric cells in Analysis toolpak?
Instead of using the wizard use the Correl function entered on the worksheet.
It will ignore text values in the data... =CORREL(B5:B99,C5:C99) -or- You could sort your data and only use the numerical portion (text sorts separately). -- Jim Cone Portland, Oregon USA http://www.realezsites.com/bus/primitivesoftware (Excel Add-ins / Excel Programming) "toloughlin" wrote in message When using the Correlation Function in the analysis toolpak, I get an error message if my dataset contains non-numeric fields. Is there a way to get Excel to ignore fields that are non-numeric? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I ingnore non-numeric cells in Analysis toolpak?
thanks. I really appreciate the help. I ended up doing a 'replace' of the
fields that I knew were the text fields and it worked. I just replaced them with blank fields and it worked. I had too many columns to do a correl function for each one but I really appreciate your advice. It's really cool to see people offering help to strangers. "Jim Cone" wrote: Instead of using the wizard use the Correl function entered on the worksheet. It will ignore text values in the data... =CORREL(B5:B99,C5:C99) -or- You could sort your data and only use the numerical portion (text sorts separately). -- Jim Cone Portland, Oregon USA http://www.realezsites.com/bus/primitivesoftware (Excel Add-ins / Excel Programming) "toloughlin" wrote in message When using the Correlation Function in the analysis toolpak, I get an error message if my dataset contains non-numeric fields. Is there a way to get Excel to ignore fields that are non-numeric? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Analysis Toolpak | Excel Discussion (Misc queries) | |||
Analysis toolpak | Excel Discussion (Misc queries) | |||
analysis toolpak | Excel Discussion (Misc queries) | |||
Analysis toolpak | Setting up and Configuration of Excel | |||
Analysis ToolPak installed but no Data Analysis option | Excel Discussion (Misc queries) |