Solved: Taking lastest elements of a list - Page 2

Danilo_Montuan · 07-28-2021 11:20 AM

Hi!

A simple question. How do i do to take lastest elements of a list? For example:
Supose i have this: {a , b , c , d , e , f , g , h , i , j}. So I need to generate a new list taking the lastest four elements from this list, that are {g , h , i , j}. It would be {j , i , h , g} anyway, because the order that these elements come up isn’t important to me.

Whats the most simple way to do it?

Steve

The approach I provided above can be applied generally.

Identify the criteria to choose the rows that will provide the wanted values.
Use FILTER() to find the rows that match the criteria from (1). Use ORDERBY() to order the rows as desired. Use TOP() to limit the number of rows. Store the resulting ordered list of row references in a virtual column.
Using a list dereference, derference the list from (2) to get the values from the needed column of the rows.

View solution in original post