Would you consider using a pivot table? If necessary, add a row at the
top of your data that contains the field names.

XL97: Click into your data and select Data Pivot Table Report. When
the Pivot Table Wizard appears, click Next to accept the default
"Microsoft Excel List or Database". Click Next if the Wizard has
correctly detected your database range. Then drag Field1 from the list
on the right into the area that is marked ROW and drag Field2 into the
area marked DATA. This will probably be converted into "Sum of Field2".
If so, double-click on "Sum of Field2" and change "summarize by" from
Sum to Average. Click OK to accept this change and then click Finish to
close the Wizard and place your pivot table into a new sheet.

If this isn't suitable or you need more help with pivot tables, post
back.

--
HTH,
Dianne

In ,
SS typed:
I have two columns of data something like

1 10
2 11
2 12
2 11
2 13
3 15
4 16
5 17
5 19
5 17
5 17
6 20
6 20
6 20
6 21

From this I want to make another table of data
I want, where the numbers are duplicated in the LH column, to take
that number and put it in the new column once but have the values
from the second column averaged and put in as one value.

e.g.

new column would be

1 10
2 all the numbers corresponding to this value added and averaged.
3 15
4 16
5 all the numbers corresponding to this value added and averaged.


can this be done??


===================================

Alternatively can I form two new columns by taking every fourth pair
form the original columns and putting them into the new columns.