Finding a Minimum within Cell

[Whylucky]

So im not sure if this is possible and i have looked into some different ways of doing this with no success. Im trying to find the minimum of a column, which is simple enough, the problem is that a couple of cells have 4 different numbers in the one cell. Ideally i would like to search for the smallest number in the particular cell then look through the entire column. I have the min search for the entire column but these particular cells are giving me trouble. Any idea on how we can solve this?

 

[oldbrewer]

you need a helper column that checks if there is more than one number in the adjacent cell - if there is strip out all the numb ers and select the minimum one otherwise just use the single number in the cell - do only 2 cells have 4 numbers, could there be more, could there be 3 or 5 numbers in a cell

 

[Whylucky]

there will always be 4 in a cell, it may be more than just two cells, and i was trying to avoid the helper columns but that seems to be the best option so i will probably go with that, Thanks

 

[Rick Rothstein]

So im not sure if this is possible and i have looked into some different ways of doing this with no success. Im trying to find the minimum of a column, which is simple enough, the problem is that a couple of cells have 4 different numbers in the one cell. Ideally i would like to search for the smallest number in the particular cell then look through the entire column. I have the min search for the entire column but these particular cells are giving me trouble. Any idea on how we can solve this?

What is between the four numbers in the one cell... spaces, commas, arbitrary text (if yes, what it between the text and numbers, if anything), something else?