I have a series of columns which hold salary data for a few hundred employees
which is recorded by date. I need to work out what the average salary is for
the highest three consecutive (i.e. cells immediatly adjacent) years in 10
e.g.

06/04/05 06/04/06 06/04/07
06/04/08 Answer
Employee 1 15,000 9,000 10,000 10,000
11,333
Employee 2 14,000 15,000 16,000 17,000
16,000

I am unable to sort the rows because of the need to keep the salaries in
order and most other formulae only pick the highest out of the list.

This is a pretty exacting requirement and I am not confident this is
possible at all through Excel. Any help would be grately appreciated!

Dan