LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Alex
 
Posts: n/a
Default min for the column contaning text

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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Return SEARCHED Column Number of Numeric Label and Value Sam via OfficeKB.com Excel Worksheet Functions 23 January 30th 06 06:16 PM
Wrap text in column headers to fit text in column MarkN Excel Discussion (Misc queries) 10 November 11th 05 04:21 AM
Count Position of Filtered TEXT cells in a column Sam via OfficeKB.com Excel Worksheet Functions 8 May 18th 05 04:23 AM
Count Position of Filtered TEXT cells in a column Sam via OfficeKB.com Excel Worksheet Functions 0 May 15th 05 08:14 PM
Sort or Filter option? Mcobra41 Excel Worksheet Functions 3 February 23rd 05 07:22 PM


All times are GMT +1. The time now is 05:05 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"