hi guys i want to know the last value of a row like this on my table
<tbody>
</tbody>
A | B | C | D | E | F | G | |
---|---|---|---|---|---|---|---|
1 | |||||||
2 | Table 1 in Sheet 1 | ||||||
3 | 2016 | 2017 | 2018 | 2019 | 2020 | ||
4 | Apple | 6,565.00 | 1,321.00 | 16,516.00 | 8,491.00 | ||
5 | Grapes | 4,819.00 | 51,651.00 | 15,651.00 | 1,984.00 | ||
6 | Orange | 8,191.00 | 151,651.00 | 1,561.00 | 89,459.00 | ||
7 | |||||||
8 | Table 2 in Sheet 2 | ||||||
9 | Apple | 8,491.00 | |||||
10 | Grape | 1,984.00 | |||||
11 | Orange | 89,459.00 | |||||
12 |
<tbody>
</tbody>
Sheet1