How to return a last value in range??

Discuss the spreadsheet application

How to return a last value in range??

Postby chanmc » Fri Jan 25, 2008 9:57 am

I need help in trying to get the calc to return LAST VALUE IN A RANGE. Please help.
chanmc
 
Posts: 1
Joined: Fri Jan 25, 2008 9:52 am

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

Postby Villeroy » Fri Jan 25, 2008 11:05 am

=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, no OpenOffice, LibreOffice 6.4
User avatar
Villeroy
Volunteer
 
Posts: 28825
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany


Return to Calc

Who is online

Users browsing this forum: No registered users and 20 guests