Average a range of data with leaving out one value each time [Closed]

Report
Posts
1
Registration date
Friday January 22, 2016
Status
Member
Last seen
January 22, 2016
-
Hello,

I'm trying to write a macro to calculate the onset time of LRP. I need to average 30 columns with leaving out one column each time. For example, in the 31st column, I'd like to enter the value of averaging column 2 to 30, and in the 32nd column I'd like to enter the value of averaging column 1 and 3 to 30. This is just like the Jackknife method. Totally there're 30 columns and 200 rows.

Would you please help me with the macro?

Thanks a lot

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!