**URGENT HELP NEEDED** please!! obtain the last non zero value from a non consecutive set of cells

[humberto_wdy]

Hi!,

I've just registered on this forum as I was looking for someone to help me with a formula I'm trying to figure so i can finish a document for a project I've been working on the last 48 hours... it may be simple but at this time my brain is fried...

This is what i want to do:

I want to obtain the last non zero value from a non consecutive set of cells in the same row... here is an example
______ A B C D E F G H I J T

Row 1: 3 4 4 2 7 5 0 6 7 0 6

I want the formula to look in the row 1 for the data in the B1 E1 H1 & J1, and show me in the cell T1 which number is the furthermost to the right without that number being a zero, in this case, the answer would be 6, located in the cell H1...

Any support is greatly appreciated.

 

[sanrv1f]

Welcome to the Board,

What is the logic behind selecting columns B,E,H &J?

 

[jasonb75]

Maybe

=LOOKUP(2,1/CHOOSE({1,2,3,4},B1,E1,H1,J1),CHOOSE({1,2,3,4},B1,E1,H1,J1))

 

[humberto_wdy]

There is data in the other columns that is relevant for other purposes but not for this one

 

[Rick Rothstein]

I want to obtain the last non zero value from a non consecutive set of cells in the same row... here is an example
______ A B C D E F G H I J T

Row 1: 3 4 4 2 7 5 0 6 7 0 6

I want the formula to look in the row 1 for the data in the B1 E1 H1 & J1, and show me in the cell T1 which number is the furthermost to the right without that number being a zero, in this case, the answer would be 6, located in the cell H1...

You show single digit values in your cells, but I am guessing that is for example purposes only. What is the maximum value that any of those cells could possibly contain?

 

[shg]

Perhaps

=1 / LOOKUP(9E+307, 1 / CHOOSE({1,2,3,4}, B1,E1,H1,J1))

 

[humberto_wdy]

You show single digit values in your cells, but I am guessing that is for example purposes only. What is the maximum value that any of those cells could possibly contain?

Indeed it is for example purposes only...

I guess the max value could be a million, 1,000,000

 

[humberto_wdy]

Perhaps

=1 / LOOKUP(9E+307, 1 / CHOOSE({1,2,3,4}, B1,E1,H1,J1))

THANK YOU!!!!...

It works!!! I want to cry out of happiness!!...

 

[Rick Rothstein]

Indeed it is for example purposes only...

I guess the max value could be a million, 1,000,000

Okay, my idea for a real simple formula is "out the window" Give this a try (still pretty simple)...

=IF(J1,J1,IF(H1,H1,IF(E1,E1,IF(B1,B1,""))))

 

[shg]

We can cry together ...