Aggregate Equivalent in Google Sheets

Hello All,

Can someone please tell me how I can find the MAX value in columns where there are errors (#N/A)?

I have two columns and I need the third column to return the MAX value it can find from columns A & B.

Sample:
$1.50 $2.50
$3.50 $2.00
#N/A $3.50
#N/A $1.50

Unfortunately, I am not sure what the equivalent of aggregate function is in Google Sheets. I tinkered around the MAXIFS function but its not working. I only have two columns for the data and the third column is where I want to get the result.

are you able to post link to sample workbook so the issue can be seen, and hopefully a solution found?

alternatively, modify your formulas to hide, or better still FIX the errors.

You can use an array formula like this;

Please Login or Register  to view this content.

Thank you very much! This worked.

I was about to post the link to my sheet but this solved my issue.