automatic correlation matrix by rows

avallepa

New Member
Joined
Jun 12, 2009
Messages
1
Hi all, I am a total novice to VBA and I need to build a macro that takes
data ordered by row (each rows has about 15 data cells) and calculate a correlation matrix.
Thus comparing each row with each other.

I know that Tools/data analalysis/correlation is the command I need
but I need an automatic update each time I add a column.

Any one could help me please!!! :):confused:
Thanks !!!!
 

Some videos you may like

Excel Facts

Using Function Arguments with nested formulas
If writing INDEX in Func. Arguments, type MATCH(. Use the mouse to click inside MATCH in the formula bar. Dialog switches to MATCH.

Watch MrExcel Video

Forum statistics

Threads
1,118,878
Messages
5,574,781
Members
412,617
Latest member
mlharris
Top