Hello everyone, I'm having trouble solving this problem with just Excel functions. I would rather not use a macro or CTRL + SHIFT + ENTER. An example or demo is attached. The idea is to find the maximum date from column G while considering each interval based on the value in column A. It's important to remember that a block of types for instance, F another F, T another T, and so on, it is not necessary; what matters is that the interval ends when another type F, T, or Z, begins, and the maximum must be determined. Type I can only provide information about dates. If it is understood correctly, please let me know. thx

Attached Files

demo.xlsx (10.6 KB, 6 views)