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 | 2250 | June 23, 2019 |
| max with condition |
|
4 | 2036 | July 31, 2021 |