Averages with Cells of Same Value

[jsparks]

Hello, this is my first time posting here so I hope it works. I have received a lot of help here on other issues.

I have a group of data:

2.1	42.5	6384.0
2.2	42.5	6341.0
2.3	42.5	6342.0
2.4	42.5	6341.0
3.5	24.3	5306.0
3.6	24.3	5280.0
3.7	24.3	5255.0
3.8	24.3	5251.0
3.9	24.3	5251.0
4.0	24.3	5251.0
4.9	15.6	4906.0
5.0	15.6	4898.0
5.1	15.6	4890.0
5.2	15.6	4880.0
5.3	15.6	4881.0
6.5	4.5	4536.0
6.6	4.5	4522.0
6.7	4.5	4515.0
6.8	4.5	4509.0
6.9	4.5	4509.0
7.0	4.5	4509.0
7.5	0.0	4256.0
7.6	0.0	4256.0
7.7	0.0	4256.0
7.8	0.0	4256.0
7.9	0.0	4256.0
8.0	0.0	4256.0
8.1	0	4256
8.2	0	4256
8.3	0	4256
8.4	0	4256
8.5	0	4256
8.6	0	4256

<colgroup><col><col><col></colgroup><tbody>
</tbody>

Essentially, what I need to do is write a visual basic function that will output the average of the left and right column, when the middle column is the same. For example, the output for this data would look like this:

2.3	42.5	6352.0
3.8	24.3	5265.7
5.1	15.6	4891.0
6.8	4.5	4516.7
8.1	0	4256.0

<colgroup><col><col><col></colgroup><tbody>
</tbody>

I am kind of lost here, any help would be very appreciated.

Thanks!