Calculating highest value in a string of values

  • Thread starter Thread starter annielago
  • Start date Start date
A

annielago

I need to identify the highest value in a string of
numbers. For instance, I have five cells, each with a
value between 1 and 6. I need the highest value in a 6th
cell. I'm sure it can be done, just can't figure out
how...
 
Hi
not sure you mean strings?. If you have values in a range (lets say
A1:A5) you could use
=MAX(A1:A5)
to return the maximum value
 
=MAX(A1:A5)

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
String probably wasn't the right word. I have values in
cells M11, Q11, U11, and Y11. I need to put the highest
value from these cells in I11. There are additional
columns in between these which also have values but I
don't want to include these in my range.

Just figured it out, I put commas in between each of these
cells in my formula...should have checked function wizard
first. Your response below definitely helped! Thanks
very much.
 
--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
=max(M11,Q11,U11,Y11)

another
=Large((M11,Q11,U11,Y11),1)

Using large, you could find the second largest by changing the 1 to 2 as an
example.
 
Back
Top