min for the column contaning text

[Guest]

I have a column with text cells. I want to find MIN for numbers inside these
text cells that are before " /" or "/".

I'm getting the numbers by using the following formula:
=IF(ISNUMBER(TRIM(LEFT(I7,FIND(" /",I7)))*1),TRIM(LEFT(I7,FIND("
/",I7)))*1,"")

But, I need to get the MIN for the whole column I2:I30 (without using an
additional column to get the numbers and after that to find the MIN) as I'm
going to refer to this sheet from a different sheet.

I'm trying
=MIN(IF(ISNUMBER(TRIM(LEFT(I2:I30,FIND("
/",I2:I30)))*1),TRIM(LEFT(I2:I30,FIND(" /",I2:I30)))*1)) but of course it's
not working.
Can anybody help me with it?

Thanks

 

[Biff]

Hi!

I'm trying
=MIN(IF(ISNUMBER(TRIM(LEFT(I2:I30,FIND("
/",I2:I30)))*1),TRIM(LEFT(I2:I30,FIND(" /",I2:I30)))*1))

Are you entering that formula as an array? It works for me.

Enter it using the key combo of CTRL,SHIFT,ENTER. That is, type the formula.
Hold down both the CTRL key and the SHIFT key then hit ENTER.

Biff

 

[Biff]

Ooops!

I missed this: (it might be one of "those" days!)

that are before " /" or "/".

Try this: (array entered)

=MIN(IF(ISNUMBER(TRIM(LEFT(I2:I30,FIND("/",I2:I30)-1))*1),TRIM(LEFT(I2:I30,FIND("/",I2:I30)-1))*1,""))

Biff

 

[Guest]

Thank you very much, Biff. It's working perfectly.

 

[Biff]

You're welcome. Thanks for the feedback!

Biff

Thank you very much, Biff. It's working perfectly.