MAXROW-related question. I realize that MAXROW returns the row with the highest value in the column specified in the second parameter. So. MAXROW(Runs,Date), in my case, returns the row in the Runs table with the most recent date. (Great description of the function here, by the way: https://plus.google.com/109264770281245493545/posts/GFX5y9anv5Z)
Ok, so how do I go about accessing one of the columns in that row? Say Runs had four columns, A, B, C, and D. How do I get the value of column C in that maxrow?
Thank you!
@Charlie_Wells Put your MAXROW into the app formula of virtual column called โMost recent runโ. Then you can access columns like so: [Most recent run].[A]
Simply beautiful and very elegant. Thank you! I am head over heels in love with this tool; you guys are great.
User | Count |
---|---|
41 | |
28 | |
24 | |
24 | |
13 |