Hi Biff,

Thank you very much. Works Great!

Cheers,
Sam

T. Valko wrote:
Are there any empty cells in your date column? Empty cells will evaluate as
month 1 (Jan).
Array entered:

=MAX(IF(MONTH(INDEX(Data,,2))=1,INDEX(Data,,COLUM NS($A:F))))
Copy across a total of 3 cells.
For other months replace the 1 with the appropriate month number or use a
cell to hold that number and then refer to that cell.

Biff

--
Message posted via http://www.officekb.com