Wishmaster89
Board Regular
- Joined
- Jan 10, 2022
- Messages
- 77
- Office Version
- 2021
- 2019
- 2016
- Platform
- Windows
- MacOS
Hi All
I'd like to get the max status from column B based on the latest start date from column C. So the max status in this example should be as 12/01/2021 is the max start date. I thought i had the answer when i used max ifs in column t but then realised its obviously not taking the start date into account.
I'd like to get the max status from column B based on the latest start date from column C. So the max status in this example should be as 12/01/2021 is the max start date. I thought i had the answer when i used max ifs in column t but then realised its obviously not taking the start date into account.
Book9 | ||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | I | J | K | L | M | T | U | V | W | X | |||||||||
1 | ULN | Completion Status | Start Date | Start Year | Learning_Actual_End_Date converted | Withdrawal time frame(days) | Months | Standard | hybrid end year | Year | Restart indicator | max HEY | hybrid year with max | Max status | MIN Start date | Start year | Max status if 17/18 | Max status if 18/19 | ||||||||
2 | 1 | 1 | 18/07/2019 | 2018 | not in a category | Maths | 17/01/2021 | 20/21 | 1 | 30/11/2021 | 21/22 | 6 | 18/07/2019 | 18/19 | 6 | |||||||||||
3 | 1 | 3 | 12/01/2021 | 2020 | 19/07/2021 | 188 | not in a category | Maths | 30/11/2021 | 21/22 | 1 | 30/11/2021 | 21/22 | 6 | 18/07/2019 | 18/19 | 6 | |||||||||
4 | 1 | 6 | 18/07/2019 | 2018 | 14/09/2020 | 424 | 13-18 | Maths | 17/01/2021 | 20/21 | 1 | 30/11/2021 | 21/22 | 6 | 18/07/2019 | 18/19 | 6 | |||||||||
Sheet1 |
Cells with Conditional Formatting | ||||
---|---|---|---|---|
Cell | Condition | Cell Format | Stop If True | |
A2 | Cell Value | duplicates | text | NO |
A1:A1043475 | Cell Value | duplicates | text | NO |