Forum Discussion

ddigger62's avatar
ddigger62
Copper Contributor
May 24, 2018

Excel Formula Help

Hello,   I need assistance with an Excel formula, please.  I've been struggling with this for hours; your help is greatly appreciated.   I have a spreadsheet with 3 columns.  The three columns ar...
Formulas & Functions
Need Help formula
Haytham Amairah's avatar
Haytham Amairah
Silver Contributor
May 24, 2018

Hi,

 

Please try this formula:

=MAX(IF((E4=A2:A20)*(F4=B2:B20),C2:C20))

 And find it in the attached file.

 

Note: To enter this formula, you have to press Ctrl+Shift+Enter at the same time, because it's an array formula.

 

Regards

 

Resources