[Solved] Find highest number in a column

Discuss the spreadsheet application
Post Reply
mikelongbeach
Posts: 22
Joined: Mon Jan 18, 2010 11:52 pm

[Solved] Find highest number in a column

Post by mikelongbeach »

Is there a function I can use that would return the highest number in a column?
Last edited by Hagar Delest on Mon Sep 04, 2017 10:37 pm, edited 1 time in total.
Reason: tagged [Solved].
OpenOffice 4.1.6 on Windows 7
Top
User avatar
Villeroy
Volunteer
Posts: 31363
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Find highest number in a column

Post by Villeroy »

The MAX function.
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
Top
User avatar
JohnSUN-Pensioner
Volunteer
Posts: 876
Joined: Fri Jan 14, 2011 1:21 pm
Location: Kyiv, Ukraine

Re: Find highest number in a column

Post by JohnSUN-Pensioner »

What about MAX()? I mean something like

Code: Select all

=MAX(C1:C65535)
I may not have a lot to give but what I got I'll give to you...
Apache OpenOffice 4.1.5, LibreOffice 6.4.4.2 (x64) on Windows 7
If you think that I did not answer your question, make allowances for my imperfect English
Top
mikelongbeach
Posts: 22
Joined: Mon Jan 18, 2010 11:52 pm

Re: Find highest number in a column

Post by mikelongbeach »

That's just what I needed, thanks.
OpenOffice 4.1.6 on Windows 7
Top
Post Reply

Return to “Calc”