Solved

EXCEL - formula for finding the highest number

Posted on 1998-03-01
2
2,299 Views
Last Modified: 2010-08-05
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
Comment
Question by:abd051697
2 Comments
 
LVL 3

Accepted Solution

by:
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

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

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Recently Microsoft released a brand new function called CONCAT. It's supposed to replace its predecessor CONCATENATE. But how does it work? And what's new? In this article, we take a closer look at all of this - we even included an exercise file for…
In this article we discuss how to recover the missing Outlook 2011 for Mac data like Emails and Contacts manually.
This video shows where to find the word count, how to display it, and what it breaks down to in Microsoft Word.
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…

809 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question