Find max of two different rows

Hi AppSheet,

I know how to use MAX() and MAXROW() but I haven’t been able to figure out a way to find the maximum of 2 different rows in two different tables. Does anyone have any ideas?

Thank you. :slight_smile:

What does this mean?

1 Like

So there is column A in table 1 and column B in table 2, all made up of numbers. I want to find the ONE highest number out of ALL of the numbers in both columns A and B.


MAX(table 1[column A] + table 2[column B])

See also:


That worked :slight_smile:

1 Like