List filtering without SELECT() or FILTER()

[Kirk_Masden]

I have what I think is a somewhat unusual question.

Let’s say I have a list as follows:

{1, 3, 5}

What I want to do is to removed all values from the list that are above or below a certain value. So, if I removed every element of the list that is less than 2, my list would be as follows:

{3, 5}

I know how to do this if I have a column with with various values. However, that is not the case I am faced with today. Today, I have column in which each cell might have multiple values as follows:

1, 3, 5

I’d like to use SPLIT() to make each cell into a list and then compare the values in the list with a value in another cell to get rid of those values that are less than it. Can that be done? If there’s no better way, I think I might be able to combine SORT() and INDEX() in a convoluted expression that can handle a finite number of list items but I’m wondering if there’s a simpler way.