Hello,
I have a range of data looking like this over multiple rows
A 0 0 0 2 3 5
B 0 1 3 5 8 9
C 0 0 2 8 10 12
I need a formula that is going to bring back the 1st, 2nd, 3rd value for each row greater than zero.
So I need it to look like this
1st value over 0 2 value over zero 3 value over zero
A
B
C
I have a range of data looking like this over multiple rows
A 0 0 0 2 3 5
B 0 1 3 5 8 9
C 0 0 2 8 10 12
I need a formula that is going to bring back the 1st, 2nd, 3rd value for each row greater than zero.
So I need it to look like this
1st value over 0 2 value over zero 3 value over zero
A
B
C