Forum Discussion

dp3450's avatar
dp3450
Copper Contributor
May 07, 2021

Getting the value from the last row in a table

I have an excel sheet with multiple tables defined (FIN, AR, MT...etc) Each table has the same column structure (Income, Expense, Total). From Each table, I need to get the value from the Total col...
  • HansVogelaar's avatar
    May 07, 2021

    dp3450 Try this:

     

    =INDEX(FIN[Total],ROWS(FIN))

Resources