Hey there, wanna hear a secret

Hobby

Postby BeerCur on Sat Aug 04, 2012 6:15 pm

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"))
The Dog of Beers
User avatar
BeerCur
Site Admin
 
Posts: 133
Joined: Mon Aug 26, 2002 4:43 pm
Location: USA - PA

Return to Announcement

  • VISITORS

Users browsing this forum: No registered users and 23 guests

Design by GB