Finding relationships between cells

[Dawny]

I have a problem and I am stuggling to think of a solution. Can anyone help please?

I have a spreadsheet with lots of columns of data. Is there a way of finding relationships between the different columns of data without having to chart them (far too many to do that)

Im no way an expert in excel so would like a simple solution if possible.

Thanks in advance

 

[lozzablake]

What do you mean by a relationship? You could use any of the following:

1) CORREL function (correlation) between any two sets of data

2) Regression analysis between two sets of data (Tools->Data analysis)