Subjected
Nope.
Then my shenanigans will have to do…
SUBSTITUTE(TEXT(TOP(SPLIT([WBS Code],"."), COUNT(SPLIT([WBS Code], “.”))-1)), " , ", “.”)
FullList-TOP(FullList, COUNT(FullList)-HowManyBottoms)
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:
INDEX(FullList, COUNT(FullList))
Thanks for the effort…
But yes, it has duplicates, and I have no real sort order column that I can grab on to…
User | Count |
---|---|
42 | |
34 | |
27 | |
23 | |
16 |