Iterative Macro - Correlation

[rheepa]

Hi All,

Can someone help me with an iterative macro? I want to calculate correlation by group and the macro I created does not loop. I also want to append all the results, not just post the first or last one. Workflow is attached.

Thanks in advance!!!

[PhilipMannering · Accepted solution]

Hi @rheepa 

I think this would work better as a Batch Macro. See my example attached.

Let me know if you have any questions!

[rheepa]

Hi. This worked perfectly! Thank you so much!