Reply to thread

Message: [QUOTE="Ron Rosenfeld, post: 7392951"] You don't give any indication of the significance of the date in D31; nor can I guess at that from what you have written. The latest date in (a11:a15,a21:a25) is given by the formula: This formula must be **array-entered**: =MAX(MAX(A11:A15*(B11:B15<>1)*(C11:C15<>1)),MAX(A21:A25*(B21:B25<>1)*(C21:C25<>1))) ---------------------------------------- To **array-enter** a formula, after entering the formula into the cell or formula bar, hold down <ctrl><shift> while hitting <enter>. If you did this correctly, Excel will place braces {...} around the formula. [/QUOTE]