Why not ask in worksheet.functions
news://msnews.microsoft.com/microsof...heet.functions
--
Regards,
Tom Ogilvy
"Richard Buttrey" wrote in
message ...
I have a database consisting of several types of record, (each
identified with a unique code), and each record has a date field.
The database has a varying number of records in each month, i.e not
necessarily one for each day.
I need to be able to identify the last record of each month for each
type of record, and sum the various value fields of each record type
across a range of months.
Can anyone suggest an Excel formula, which could be put outside the
database in a summary table, which could achieve this?
Usual TIA
Rgds
__
Richard Buttrey
Grappenhall, Cheshire, UK
__________________________