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

Subjected

Nope.

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

2 Likes

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

1 Like

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

2 Likes

True, I am assuming no duplicates.

1 Like

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

4 Likes

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

1 Like