Solved

EXCEL - formula for finding the highest number

Posted on 1998-03-01
2,298 Views
i have a set of numbers in a column, and i need a formula to find the highest or lowest number
in the set.

has someone got a formula to help me out, i don't even know where to start. i guess you would
use a lot of greater thans and less thans??
0
Question by:abd051697

LVL 3

Accepted Solution

ckezema earned 100 total points
ID: 1610673
if you want to find the highest number is a list use the MAX function...

Highlight the cell where you want the answer to go, type an equal (=) sign, this will put you into formula edit mode...

type this formula...=max(the range)
for example if I wanted to find the highest number in a range of cells (range being a1 to g50)I would type in the cell...

=max(A1:G50)

To find the smallest number just change max to min...

ex:  =min(A1:G50)

Hope this helps..let me know if you have any questions

Conan
0

Author Comment

ID: 1610674
your'e a legend!! thanks :)
0

Featured Post

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Microsoft Office Picture Manager is not included in Office 2013. This comes as a shock to users upgrading from earlier versions of Office, such as 2007 and 2010, where Picture Manager was included as a standard application. This article explains how…
In this article we discuss how to recover the missing Outlook 2011 for Mac data like Emails and Contacts manually.
This video shows the viewer how to set up and create Footnotes in their document. Click on the References tab: Select "Insert Footnote": Type in desired text:
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…