How to return a last value in range??

Discuss the spreadsheet application
Post Reply
chanmc
Posts: 1
Joined: Fri Jan 25, 2008 9:52 am

How to return a last value in range??

Post by chanmc »

I need help in trying to get the calc to return LAST VALUE IN A RANGE. Please help.
User avatar
Villeroy
Volunteer
Posts: 31269
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: How to return a last value in range??

Post by Villeroy »

=INDEX(range;ROWS(range);COLUMNS(range))
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Post Reply