I've tried everything I can think of or research and can't find out how to do this. I'm trying to return the last column value in a row - Row 3. See below for an example. There are dates that I don't want counted and there is a formula in each column which I don't want counted either. As you can see in column O - it's not pulling the 0.00% in column J like I need.
<tbody>
</tbody>
| | H | I | J | K | L | M | N | O |
1 | | Variance RLP Transmittal | Lease Award | Variance Lease Award | TI Costs Approved and NTP Provided | Variance NTP | Lease Term Commencement | Variance Lease Commencement | Total |
2 | | 12/18/2015 | 2/28/2017 | 6/6/2017 | |||||
3 | | 0.00% | 12/18/2015 | 0.00% | -2530.50% |
<tbody>
</tbody>