Help needed with macro: Writing contents of two cells to two new columns

B

Big B

Can any macro programming experts please help a newbie with this one:

I will have two same-size matrices and need to create two new columns
(all in the same sheet) by choosing, for each row, a number from the
first matrix and the number from the matching cell in the second
matrix. As follows:

For each row:
I need to find the cell in the first matrix whose contents is the
maximum from its row mean (maximum deviation from the row mean). Then
write to two new columns, the number in that cell, and the number in
the corresponding cell of the second matrix.

I will need to run the macro with matrices of various sizes up to 30
rows and 700 columns so number of rows and columns could be parameters,
or annotation in the macro clearly show what settings to change.

Your help will be much appreciated as I've spent ages trying to do
this.

Thanks in advance

Big B
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top