PDA

View Full Version : Find the 2nd 3rd, 4th value over zero in a range



SuzanneHA
2016-10-17, 06:49 PM
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

navic
2016-10-17, 10:06 PM
1st value over 0 2 value over zero 3 value over zeroSee solution in attached example

SuzanneHA
2016-10-17, 10:26 PM
Thank you!