# Max Row with Range

i created a table in my sample doc and in another view of my main table, i get max row. I added a new column to my sample doc that name is ‘range’. if i want to get max of column value when range column is over 1000, what should i do??

Here’s an updated doc:

Let me know if it makes sense or if you’d like some more explanation.

1 Like

Thank you so much @Nick_HE
I set the range controller to 1500 but no value is displayed in the Top 5 values ​​table (with range over 1000). What is the reason for this?

Aha - it’s an issue with the earlier formula; if there are less than 5 results, no results are shown (the same thing would happen with the original doc if you deleted a bunch of rows leaving only 4).

Fixed now. Basically the formula means: If there are at least 5 rows to start with, do the thing where we grab any rows that are better than the 5th row. Otherwise, just include all rows (in a filter, you can let everything through by just saying “true”)

Thank you so much @Nick_HE

I just realized that this thread has separated from the original thread - I hadn’t noticed that when I picked up working on this question (that was already asked in the previous thread).

I came up with a bit different solution than @Nick_HE , I worked it out without an intermediate table.

Use whatever you are most comfortable with - I added my solution to the original doc.

Greetings,
Joost

Thanks for the great solution @joost_mineur

@Nick_HE
If I want to get 5 lines with the Min value, what formula should I write?

Basically you would be looking for values that are less than the 5th lowest value

So instead of checking if `thisRow > ...` you would check if `thisRow < ...`

Then to find the 5th lowest value:
You’re currently using `Sort(...something..., False)`, which means sort descending (with the largest first).
You’ll need to adjust your formula to instead be `Sort(...something..., True)` which means sort ascending (lowest first)

So change the > to < and the “False” to “True” and you should be on your way

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.