Hello everyone,
I am very new to VBA so excuse me if my problem appears to be trivial for some of you.
Let me explain the situation :
I have a table consisting of 96 columns and 160 lines. I have been measuring things in triplicate, so each three columns are concerning the same sample (A B C = from sample 1, C D E = from sample 2 ...)
I want to avoid to manually calculate the average of each value per line per sample. I am struggling to make an iterative loop to perform the calculation for each seat of 3 columns.
As each sample has a name that was manually entered on top of each columns (I tried some things using "basic" Excel), the perfect thing would be to make a formula that calculates the average of 3 columns IF they have the same name as the previously specified ones.
Thank you if you can help
I am very new to VBA so excuse me if my problem appears to be trivial for some of you.
Let me explain the situation :
I have a table consisting of 96 columns and 160 lines. I have been measuring things in triplicate, so each three columns are concerning the same sample (A B C = from sample 1, C D E = from sample 2 ...)
I want to avoid to manually calculate the average of each value per line per sample. I am struggling to make an iterative loop to perform the calculation for each seat of 3 columns.
As each sample has a name that was manually entered on top of each columns (I tried some things using "basic" Excel), the perfect thing would be to make a formula that calculates the average of 3 columns IF they have the same name as the previously specified ones.
Thank you if you can help
