max-with-condition
Topic | Replies | Views | Activity | |
---|---|---|---|---|
How can I find the latest date in a non-contiguous range (e.g. C5, C10, C15...) that is also earlier than the date in another cell (e.g. A1)? | 6 | 2160 | June 23, 2019 | |
max with condition | 4 | 1971 | July 31, 2021 |