Oct 27 2022 10:11 AM
Oct 27 2022 10:42 AM
A few options might work for you depending on version and data set.
Formula (see attached xlsx):
You might also consider creating a custom list and then sorting on the custom list if the number of unique items you have is reasonable.
Oct 27 2022 10:56 AM