Hi everyone,
I am trying to use some data to find the minimum and maximum values using the MINIFS and MAXIFS function.
However one of my criteria needs to have multiple answers, so the answer of a range could be 'A' or 'B' etc
So far I have got it to return an result for one answer but I also need it to look up other values too as they could be the correct answer instead.
I cannot upload the sheet because it is confidential, any ideas would be greatly appreciated
I am trying to use some data to find the minimum and maximum values using the MINIFS and MAXIFS function.
However one of my criteria needs to have multiple answers, so the answer of a range could be 'A' or 'B' etc
So far I have got it to return an result for one answer but I also need it to look up other values too as they could be the correct answer instead.
I cannot upload the sheet because it is confidential, any ideas would be greatly appreciated