Hey, guys,
I'm really going crazy with this as I have not been able to figure it out for a couple of days.
Let's take the following picture as an example:
I'm basically looking for a formula on input on column D which does the exact same thing but with one exception. Let's say we on row 21 we have data exactly as we do on row 19. In that case, I want the formula to return the "2" as it did on row 19.
Any idea how this can be achieved?
I'm really going crazy with this as I have not been able to figure it out for a couple of days.
Let's take the following picture as an example:

I'm basically looking for a formula on input on column D which does the exact same thing but with one exception. Let's say we on row 21 we have data exactly as we do on row 19. In that case, I want the formula to return the "2" as it did on row 19.
Any idea how this can be achieved?