Home |
Search |
Today's Posts |
#1
|
|||
|
|||
i need a function to find the highest value in a list
Hi,
I've got a bunch of numbers and its a long list of numbers. I need to find the biggest one in the list. Is there a way of doing this with a function. Thanks in advance Melani |
#2
|
|||
|
|||
Hi Melani
use =MAX(A1:A100) where A1:A100 is the range of your long list of numbers -- Cheers JulieD check out www.hcts.net.au/tipsandtricks.htm ....well i'm working on it anyway "Melani" wrote in message ... Hi, I've got a bunch of numbers and its a long list of numbers. I need to find the biggest one in the list. Is there a way of doing this with a function. Thanks in advance Melani |
#3
|
|||
|
|||
Hi
use the MAX function e.g. =MAX(A1:A100) where A1:A100 is your long list of numbers -- Cheers JulieD check out www.hcts.net.au/tipsandtricks.htm ....well i'm working on it anyway "Melani" wrote in message ... Hi, I've got a bunch of numbers and its a long list of numbers. I need to find the biggest one in the list. Is there a way of doing this with a function. Thanks in advance Melani |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
What function would let me find Batting Averages? | Excel Worksheet Functions | |||
What function would let me find Batting Averages? | Excel Worksheet Functions | |||
What function would let me find Batting Averages? | Excel Worksheet Functions | |||
ISNULL function - can't find it | Excel Worksheet Functions | |||
Find a Function to use accross different worksheets | Excel Worksheet Functions |