Which is last item in the list using INDEX?

Hi Team,
i’m using INDEX and
“The first item in the list is 1.”
but the last one?

thks in advance

EX:
INDEX(select(full 1[registre], [_thisrow].[concatenatediaUsuari]=[concatenatediausuari]),1)

Indented:

INDEX(
   select(
        full 1[registre],
       [_thisrow].[concatenatediaUsuari]=[concatenatediausuari])
   ,
1)

My answer, probably something like this:

 INDEX(
    SELECT(
         full 1[registre],
        [_thisrow].[concatenatediaUsuari]=[concatenatediausuari])
    ,
  COUNT(
      SELECT(
         full 1[registre],
        [_thisrow].[concatenatediaUsuari]=[concatenatediausuari])
  )
)

Simplier:

INDEX(
   listName, 
   COUNT(ListName)
)
3 Likes

OK, thanks i know this solution but i thought that perhaps exists a “number” to identify this position.

1 Like

:rofl:

1 Like

Unfortunately, no. :frowning:

1 Like