Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Max Value of conditional list
I have a list of machines (MACHINE LIST) and another list of dates (DATE
LIST). The DATE list has the dates that each machine was used . The DATE list is much longer than the MACHINE list because each machine has been used multiple times on different dates. I want to make a report that shows the last date each machine was used. I could accomplish this by sorting the DATE list and then manually comparing the two lists. But, I'd have to do that every time they were updated. I want to automate the process. Is there a formula that would give me the max date from the DATE list for each entry on the MACHINE list.....something like a "MAXIF" Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
conditional list | Excel Worksheet Functions | |||
conditional formatting from a list | Excel Worksheet Functions | |||
Conditional List | Excel Worksheet Functions | |||
Conditional List | Excel Discussion (Misc queries) | |||
Making pick list conditional on selection from previous pick list | Excel Discussion (Misc queries) |