Which is last item in the list using INDEX?

[J_jvs]

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)

[Aurelien]

J_jvs:

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)
)

[J_jvs]

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

[Aurelien]

[Steve]

J_jvs:

i thought that perhaps exists a “number” to identify this position.

Unfortunately, no.

[Deivid_Moura]

In Python the answer would be -1 (negative index goes back and forth), it would be interesting to have this functionality in AppSheets

[Prodragus_Gamer]

To get the last value, I'd just use this below:

INDEX(LIST, COUNT(LIST))