Thread: Maximum of Selected Range

I need a function that will return whether or not (in binary form-either yes/no or 0/1) a value is the maximum for a range of codes that are equivalent to one another. For example, if codes in column A are identical, a 0/1 or yes/no must be returned in column C indicating whether or not the corresponding value in column B is the maximum for the identical A column codes. I attached a sample xls of what I'm talking about.

My spreadsheet contains hundreds of thousands of rows, so I do not have the time to manually select the ranges myself.

Thanks!

In C2 use the formula =B2=MAX(INDEX($B$2:$B$20 *--($A$2:$A$20=A2),0)) and copy down.

That will return TRUE or FALSE, if you want something different then encode it in an IF statement, e.g. =IF(B2=MAX(INDEX($B$2:$B$20 *--($A$2:$A$20=A2),0)),"Yes","No")

You're a life saver Andrew! Thanks!