Hello, i would need some help with a function.
Where i want do scan a couple of cells and return the first value that is not blank.

I have got it to work with =INDEX(J7:O7;MATCH(TRUE;INDEX((J7:O7 <> "");0);0)) but in this case, the cells are together in a range.

My problem is that the cells i want to go through are every other cell, so J7, L7, N7 , P7, R7 and T7.
Does someone know how to solve this problem?