hi All,
how can I return the last value in a range?
<tbody>
</tbody>Based on the above, I would like to return the values in D1, J1, E2and L2.
Using =LOOKUP(9.99E+307,H30:U30) will only return the value of J8.
I am looking for a formula that will return both.
Thanks for you help.
Bert
how can I return the last value in a range?
A | B | C | D | E | F | G | H | I | J | K | L | M | N | |
1 | 12 | 15 | 17 | 20 | 4 | 9 | 8 | |||||||
2 | 3 | 6 | 8 | 12 | 16 | 19 | 36 |
<tbody>
</tbody>
Using =LOOKUP(9.99E+307,H30:U30) will only return the value of J8.
I am looking for a formula that will return both.
Thanks for you help.
Bert