I want to have a formula that finds the maximum value in a list. Easy enough
but I want to add a condition - the cell to the left has to equal a cell
reference.
So for example:
If I enter the number 4 in a cell I want the formula to lookup the list
(column B) and find all listings that have 4....then find the max value in
column A.
Its kind of like a maxif but I don't know if there is such a function?

GK