Hi
I have data in 3 columns, but need to find the max of one based on certain criteria
COLUMN A contains numbers
COLUMN B contains type
COLUMN C contains location
So, for example, I need a formula in cell A20 that will be the MAX of column A above it, but only where
COLUMN B = "Contract"
AND
COLUMN C = "Amazingstoke"
Not sure on the best approach, using MAX or LARGE ? with either SUMPRODUCT or INDEX/MATCH....or maybe another method im not aware of?
I have data in 3 columns, but need to find the max of one based on certain criteria
COLUMN A contains numbers
COLUMN B contains type
COLUMN C contains location
So, for example, I need a formula in cell A20 that will be the MAX of column A above it, but only where
COLUMN B = "Contract"
AND
COLUMN C = "Amazingstoke"
Not sure on the best approach, using MAX or LARGE ? with either SUMPRODUCT or INDEX/MATCH....or maybe another method im not aware of?