Tricky Cell Population Question

**hashmio9** · 12-14-2011, 05:10 PM

I have 5 cells and I want a 6th cell to be populated by the latest cell with a value in greater than 0

e,g
So I want K3 to check J3 first and work its way backwards until it finds a cell with a value greater than 0

Example 1
A2=3
D3=0
F3=1
H3=4
J3=5

So K3=5

Example 2
A2=3
D3=0
F3=1
H3=0
J3=0

So K3 =1

I hope I have made sense. Any help would be great. I tried googling it but it was difficult to describe.

**ConneXionLost** · 12-14-2011, 05:40 PM

It's awkward to determine "backwards" in a non-contiguous range, so how about:

Please Login or Register  to view this content.

**Haseeb Avarakkan** · 12-14-2011, 06:14 PM

Try this,

=LOOKUP(2,1/CHOOSE({1,2,3,4,5},A2,D3,F3,H3,J3),CHOOSE({1,2,3,4,5},A2,D3,F3,H3,J3))

{1,2,3,4,5} is means 5 ranges (A2,D3,F3...) NOT any values.