min for the column contaning text

A

Alex

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
 
B

Biff

Hi!
I'm trying
=MIN(IF(ISNUMBER(TRIM(LEFT(I2:I30,FIND("
/",I2:I30)))*1),TRIM(LEFT(I2:I30,FIND(" /",I2:I30)))*1))
Click to expand...

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
 
B

Biff

Ooops!

I missed this: (it might be one of "those" days!)
that are before " /" or "/".
Click to expand...

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
 
Top