Thread: How do I ingnore non-numeric cells in Analysis toolpak?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
toloughlin toloughlin is offline
external usenet poster
  
Posts: 2
Default 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?
Reply With QuoteReply With Quote