find the highest value for multiple cells

[jbrow]

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?

 

[FSt1]

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

this will give the max value of the range.

Regards
FSt1

 

[Bernd P]

Hello,

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

Regards,
Bernd