Then my shenanigans will have to do…
SUBSTITUTE(TEXT(TOP(SPLIT([WBS Code],"."), COUNT(SPLIT([WBS Code], “.”))-1)), " , ", “.”)
Works only if no duplicates in FullList, and duplicates will be removed in the result.
True, I am assuming no duplicates.
Another alternative if only grabbing one item:
Thanks for the effort…
But yes, it has duplicates, and I have no real sort order column that I can grab on to…