Solved

EXCEL - formula for finding the highest number

Posted on 1998-03-01
2
2,301 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Microsoft Office Picture Manager was included in Office 2003, 2007, and 2010, but not in Office 2013. Users had hopes that it would be in Office 2016/Office 365, but it is not. Fortunately, the same zero-cost technique that works to install it with …
Outlook Free & Paid Tools
This video shows and describes the main difference between both orientations in Microsoft Word. Viewers will understand when to use each orientation and how to get the most out of them.
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…

733 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