Hello -

My spreadsheet has a list of dates and data in rows 9 through 500.
Dates are shown in Column A of these rows and data is in Column Q of
these rows. There is also a summary section in row 6, and I would
like to enter a formula in row 6 that will show the latest entry in
Column Q by month.
An example of the spreadsheet layout as well as the results to
populate in row 6 are shown below.

Nov 2007 (Col C) Dec 2007 (Col D) Jan 2007
(Col E)
Row 6 10.45 12.25
3.20

Date (Col A) Data (Col Q)
Row 9 11/27/07 10.45
Row 10 11/28/07
Row 11 11/29/07
Row 12 11/30/07
Row 13 12/01/07 12.25
Row 14 12/05/07
Row 15 01/02/08
Row 16 01/30/08 3.20

Any suggestions?