willow1985
Wellknown Member
 Joined
 Jul 24, 2019
 Messages
 633
 Office Version

 2019
 Platform

 Windows
Hello,
I am trying to get a Max IF formula to work. At first I thought of using an index match with Max however I read online that the below formula would be a better fit:
=MAX(IF(('% Complete'!A1:A6=A1),'% Complete'!$B$1:$B$7))
I need the formula to return the Maximum percentage from the list below for each color match:
% Complete
A B
<colgroup><col width="64" span="2" style="width:48pt"> </colgroup><tbody>
</tbody>
This is what the results should be:
A B
<colgroup><col width="64" span="2" style="width:48pt"> </colgroup><tbody>
</tbody>
However what I get is:
<colgroup><col width="64" span="2" style="width:48pt"> </colgroup><tbody>
</tbody>
Any help would be greatly appreciated
Thank you
Carla
I am trying to get a Max IF formula to work. At first I thought of using an index match with Max however I read online that the below formula would be a better fit:
=MAX(IF(('% Complete'!A1:A6=A1),'% Complete'!$B$1:$B$7))
I need the formula to return the Maximum percentage from the list below for each color match:
% Complete
A B
Red  50% 
Blue  10% 
Green  90% 
Yellow  50% 
Red  100% 
Red  75% 
Yellow  25% 
<colgroup><col width="64" span="2" style="width:48pt"> </colgroup><tbody>
</tbody>
This is what the results should be:
A B
Red  100% 
Blue  10% 
Green  90% 
Yellow  50% 
<colgroup><col width="64" span="2" style="width:48pt"> </colgroup><tbody>
</tbody>
However what I get is:
Red  100% 
Blue  100% 
Green  100% 
Yellow  100% 
<colgroup><col width="64" span="2" style="width:48pt"> </colgroup><tbody>
</tbody>
Any help would be greatly appreciated
Thank you
Carla