S
sony654
I want to write a function that displays the last value populated ina range.
To help explain please see below:
column A B C D E F G
H
row
1 67 55 42 66 49 39 72
56
2 56 38 44 77 59
3
4
This is what I'm trying now, doesn't work.
=IF(COUNT(a1:h4),LOOKUP(99^99,a1:h4),"-")
I want to be able to display in this case the value 59.
I need to write a function that evaluates A1:H4 and displays the last value
populated. In this case 59.
To help explain please see below:
column A B C D E F G
H
row
1 67 55 42 66 49 39 72
56
2 56 38 44 77 59
3
4
This is what I'm trying now, doesn't work.
=IF(COUNT(a1:h4),LOOKUP(99^99,a1:h4),"-")
I want to be able to display in this case the value 59.
I need to write a function that evaluates A1:H4 and displays the last value
populated. In this case 59.