Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Finding last record in month for each of several types of record.
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 __________________________ |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Finding the next record in a column | Excel Discussion (Misc queries) | |||
Open new record with selected fields from previous record | Excel Discussion (Misc queries) | |||
Finding Duplicate Record in more than one column | Excel Discussion (Misc queries) | |||
Record Macro - Record custom user actions | Excel Programming | |||
Need help autopopulating next new record with previous record data | Excel Programming |