Hello Chaps
I don't often ask for help here but this one has stumped me.
For a dashboard of sorts...
I have a list of values in column S.
Each of these has a status value in column C.
I need to find the maximum value in column S where the status matches one in a list of statuses.
The table of valid status values is in A2:A6
So something like "=(MAX(IF(C2:C111=ValueOnStatusTable,S2:S200)))
This would work if the StatusTable was only 1 cell and matched only 1 value
A C S
X M 5
M M 8
1 1 10
2 L 13
A A 8
A 5
X 3
K 1
So, in this case the value return would 10 as its status of M is in the list
The value of 13 is not returned as its status value of L is NOT in the list
Likewise for finding the MIN value.
In that case 3 would be returned and not 1 as X is valid and K is not.
Thanks
Ray
Thanks for the reply.
I think the solution you gave was one of the many variants I tried already.
It does return a value but doesn't take the whole valid status table into account and returns just the first instance of the status.
Bear in mind that it should return the MAX value of all of those statuses not individually.
I'd prefer a Maserati but I'd settle for Mazzaropi right now.