Prev: copying and pasting certain info
Next: Referencing conditional format is another workbook using Chip Pear
From: Stephen Christian on 6 Jun 2010 19:49 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 |