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
Solved! Go to Solution.
What does this mean?
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.
Try:
MAX(table 1[column A] + table 2[column B])
See also:
That worked
Noice!
User | Count |
---|---|
41 | |
36 | |
30 | |
23 | |
16 |