Solved: Find max of two different rows

tvinci · 06-02-2020 10:53 AM

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.
Tiffany

Steve

Try:

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

See also:

View solution in original post

Steve

What does this mean?

tvinci

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.

Steve

Try:

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