Is there a BOTTOM() like there is a TOP()

[Grant_Stead]

Subjected

help.appsheet.com

TOP()

Initial list items

[Steve]

Nope.

[Grant_Stead]

Then my shenanigans will have to do…
SUBSTITUTE(TEXT(TOP(SPLIT([WBS Code],"."), COUNT(SPLIT([WBS Code], “.”))-1)), " , ", “.”)

[Bahbus]

FullList-TOP(FullList, COUNT(FullList)-HowManyBottoms)

[Steve]

Works only if no duplicates in FullList, and duplicates will be removed in the result.

[Bahbus]

True, I am assuming no duplicates.

[Bahbus]

Another alternative if only grabbing one item:
INDEX(FullList, COUNT(FullList))

[Grant_Stead]

Thanks for the effort…
But yes, it has duplicates, and I have no real sort order column that I can grab on to…