find the highest value for multiple cells
 

if i have the first column with multiple repeating numbers and i need to get
the highest number from each of the set of numbers how does the formula read
or get typed? ie.. column A2 has the number 272, a3 has the number 272, A3
has the number 272,, then in column B each entry is different,, can i grab
the entry with the highest number rather than the entry that is in the first
of the series?

find the highest value for multiple cells
 

hi
if i understand correctly, look into the max function.
=max(A2:B50)

this will give the max value of the range.

Regards
FSt1

"jbrow" wrote:

if i have the first column with multiple repeating numbers and i need to get
the highest number from each of the set of numbers how does the formula read
or get typed? ie.. column A2 has the number 272, a3 has the number 272, A3
has the number 272,, then in column B each entry is different,, can i grab
the entry with the highest number rather than the entry that is in the first
of the series?

find the highest value for multiple cells
 

Hello,

Array-enter
=MAX(IF(A1:A999=272,B1:B999))
[Enter with CTRL + SHIFT + ENTER, not only with ENTER]

Regards,
Bernd