EXCEL: INPUT RANGE CONTAINS NON-NUMERIC DATA

grislobato wrote:

It says "correlation- input range contains non-numeric data" even I tried putting in NUMBER the format of the table. What I have to do?

Perhaps what appears to be numeric is actually text, which is not uncommon when you copy-and-paste data, for example.

(FYI, changing the format to Number only changes the appearance of data that is already numeric.  It does not change text data, and it does not preclude having text data in those cells.)

Suppose your data is in A1:A100 and B1:B100.  In parallel columns, enter the formulas =ISNUMBER(A1) and =ISNUMBER(B1) in rows 1:100.  Do any return FALSE?

If so, try to use the Data > Text To Columns feature for each of A1:A100 and B1:B100 separately.

Are any of the ISNUMBER results still FALSE?

If so, the data might contain non-breaking spaces (HTML nbsp; ASCII 160).  In parallel columns, enter the formulas

=--SUBSTITUTE(A1,CHAR(160),"") and =--SUBSTITUTE(B1,CHAR(160),"") in rows 1:100.  Copy those columns and paste-value into A1:B100.

Are any of the ISNUMBER results still FALSE?

If so, I suggest that you upload a redacted Excel file that demonstrates the problem (ideally before the changes that I suggested above) to a file-sharing website (e.g. box.net/files), and post the public/share URL in a response here.  Test the URL first, being careful to log out of the file-sharing website.

Are you using the function called CORREL?

No, I enable in excel add-ins: Analysis Toolpak- VBA  for data analysis and there is an option of correlation, so I tried to analyze data in a table and also select the "labels in the first row" because I had. But It continued to say that.