Page 1 of 1

Hobby

PostPosted: Sat Aug 04, 2012 6:15 pm
by BeerCur
I need to find a better hobby... This is an Excel cell formula... Could have done it 15 minute in .net, but the challenge to do it in a restrictive environment... priceless or one night of struggle in exchange

=IFERROR(IF(ISNUMBER(VALUE(MID(C91,SEARCH("|",SUBSTITUTE(C91,"m","|",
(LEN(C91)-LEN(SUBSTITUTE(C91,"m","")))))-1,1)))
,RIGHT(C91,LEN(C91)
-FIND("|",SUBSTITUTE(C91," ","|",LEN(C91)-LEN(SUBSTITUTE(C91," ",""))
-(LEN(C91)-LEN(TRIM(C91)))-1)))
,TRIM(MID(C91,SEARCH("|",SUBSTITUTE(C91,"s","|",1))-2,3)))
,IFERROR(IF(ISNUMBER(VALUE(MID(B91,SEARCH("|"
,SUBSTITUTE(B91,"m","|",(LEN(B91)
-LEN(SUBSTITUTE(B91,"m","")))))-1,1)))
,RIGHT(B91,LEN(B91)-FIND("|",SUBSTITUTE(B91," ","|"
,LEN(B91)-LEN(SUBSTITUTE(B91," ",""))-(LEN(B91)
-LEN(TRIM(B91)))-1)))
,TRIM(MID(B91,SEARCH("|",SUBSTITUTE(B91,"s","|",1))-2,3)))
,"error"))