I need help with a formula that calculates the number of consecutive cells upwards that contain higher (column D) or lower (column E) values than the actual.
I have manually made the below table, to show the desired result.
I guess this can be done with the proper combination of VLOOKUP...