redsun001
10-30-2017, 12:14 PM
Hi all,
I am new to Excel VBA and I have this problem which I need help with...
Basically if I have a columns of data such as:
X values
Y values
1
5
1
6
2
8
9
16
12
21
As you can see; for values of x=(1) I have two different y values =( 5 and 6). I need to take an average of both y values for (repeated x values) and print the entire data with average of different y values for (repeated x value).
Example output:
X values
Y values
1
5.5
2
8
9
16
12
21
Can someone please help me with this as I have spent hours trying to do this :banghead: and can't simply write a proper loop for this. I will really appreciate it if you can show me how it is done.
Thanks
I am new to Excel VBA and I have this problem which I need help with...
Basically if I have a columns of data such as:
X values
Y values
1
5
1
6
2
8
9
16
12
21
As you can see; for values of x=(1) I have two different y values =( 5 and 6). I need to take an average of both y values for (repeated x values) and print the entire data with average of different y values for (repeated x value).
Example output:
X values
Y values
1
5.5
2
8
9
16
12
21
Can someone please help me with this as I have spent hours trying to do this :banghead: and can't simply write a proper loop for this. I will really appreciate it if you can show me how it is done.
Thanks