Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hi again chaps,
I'm using the following array formula to determine the MAX value in column I3:I1002: {=IF(I1019="","",MAX(IF($G$3:$G$1002$H$3:$H$1002, I3:I1002)))} I get the MAX value from column I3:I1002 but only where corresponding values in G3:G1002 are larger than the values in H3:H1002. This appears to work fine but I now need the MAX value not only with G3:G1002H3:H1002, but also where E3:E1002F3:F1002. If someone could work the additional criteria into my formula it's be a great help. Many thanks for looking. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Filtering with multiple criteria | Excel Discussion (Misc queries) | |||
Different comparison criteria in sumproduct | Excel Worksheet Functions | |||
Filtering by criteria within PV in Excel. | Excel Discussion (Misc queries) | |||
Two cell Comparison with three different Criteria | Excel Worksheet Functions | |||
Filtering by criteria in two columns | Excel Worksheet Functions |