I have this atm:
=INDEX(B4:G4, COUNTA(B4:G4))
It shows me the last value with text, now I want to know if this value repeats in a sequence, in our case the value has to be 2
I really don't know how to do it