Hi guys...I am having a spread sheet of numerous columns and i want to find the average of some repeated values...like....
1q-2-3-4-5
1q-3-4-5-6
1q-2-4-5-3
5a-4-2-4-2
5a-3-2-7-8
i want the average of all the rows for the unique 1st column.
The answer should look like
1q-2.3-3.6-4.6-4.6
5a-3.5-2.0-5.5-5.0
Can anyone help me plz....!
1q-2-3-4-5
1q-3-4-5-6
1q-2-4-5-3
5a-4-2-4-2
5a-3-2-7-8
i want the average of all the rows for the unique 1st column.
The answer should look like
1q-2.3-3.6-4.6-4.6
5a-3.5-2.0-5.5-5.0
Can anyone help me plz....!