My 2 input ranges are D2:K2; D5:K5.
D5:K5 generates either of 0 or 1 with a condition that at a time there would be maximum one “1” in the entire range.
Output cell is T2
T2=D2:K2 where the analogous cell in the range D5:K5 is 1
If all D5:K5 is 0 (there is no “1”), then T2=0
How to accomplish? Thanks in advance.
Bookmarks