Getting the maximum line number entered for each user
I would like to change the number of lines displayed for each user.
In this case, I would like to display the 3rd to 10th lines to user A and display the 12th to 20th lines to user B.
So I exclude the number of entered lines...
I was thinking of using the RANK function, but it seems that I cannot use it if "Users" in "Applies To".
Could you tell me a good solution?