S
Srikanth Ganesan
Hi I have data in the following column format:
X Y X1 Y1 X3 Y3 ............ Average
1 3 5 2
34 2 0 4
. . .
. . .
There are many columns (X,Y,X1,Y1 ....) with numerical data in them. I
want to create two new column by name "Average X" & "Average Y". Column
"Average X" is the average of the X, X1 X2 X3.. columns. Column
"Average Y" is the average of the Y, Y1 Y2 Y3.. columns etc. How do I
write a macro to do this automatically. Please help.
Srikanth
X Y X1 Y1 X3 Y3 ............ Average
1 3 5 2
34 2 0 4
. . .
. . .
There are many columns (X,Y,X1,Y1 ....) with numerical data in them. I
want to create two new column by name "Average X" & "Average Y". Column
"Average X" is the average of the X, X1 X2 X3.. columns. Column
"Average Y" is the average of the Y, Y1 Y2 Y3.. columns etc. How do I
write a macro to do this automatically. Please help.
Srikanth