Trying to find working VBA code for the following problem:

a=maxif(column(a), column(b) = 1, column(c) < empty)

value = maxif(range, condition, condition)

Arranged in table so that the max value is returned as long as it meets the
critia on the same row.

Thanks