excel - Perform MID or LEFT on ARRAY -

-

match requires array second parameter.

eg. =match(sheet1!a1 ; sheet2!a1:a4 ; 0)

is there way match substrings of array values in lookup using left/mid?

eg. =match(sheet1!a1 ; left(sheet2!a1:a4;5) ; 0)

the above example gives #value! error, understand why not working, want know if there way acheive desired result? matching using substring each value in array?

you can array enter formula make work. that, mean need press ctrl+shift+enter after typing in formula instead of hitting enter.


Comments

Post a Comment

Popular posts from this blog

c# - Sort XmlNodeList with a specific Node value -

-
i searched web this, not able find related solution. i have following xml <table> <entity>employee</entity> <entityid>2786</entityid> <goal> <goalid>31931</goalid> <filterdata>lastmodifiedon¥2014-03-20t18:11:01.0000000+05:30Æactivetaskcount¥0</filterdata> </goal> <goal> <goalid>31932</goalid> <filterdata>lastmodifiedon¥2014-03-22t15:26:09.0000000+05:30Æactivetaskcount¥0</filterdata> </goal> <goal> <goalid>31932</goalid> <filterdata>lastmodifiedon¥2014-03-22t09:25:00.0000000+05:30Æactivetaskcount¥0</filterdata> </goal> </table> from above xml when read data got 2 separate datatables ; 1 employees , 1 related goals. what needed want sort goals related employee respect lastmodifiedon filterdata node. note: getting lastmodifiedon value split node value this ...
Read more

Android Java.Lang.RuntimeException : Unable to start activity Component Info -

-
i'm new in android programmer. recently, trying make project using google map v2 in android app, i'm getting lot of error (i have add google play services library , find similar topic in here, not solved problem).please see log cat bellow : updated 03-22 13:52:29.331: e/androidruntime(17708): fatal exception: main 03-22 13:52:29.331: e/androidruntime(17708): java.lang.runtimeexception: unable resume activity {com.yai.testmap/com.yai.testmap.mainactivity}: java.lang.nullpointerexception 03-22 13:52:29.331: e/androidruntime(17708): @ android.app.activitythread.performresumeactivity(activitythread.java:2613) 03-22 13:52:29.331: e/androidruntime(17708): @ android.app.activitythread.handleresumeactivity(activitythread.java:2641) 03-22 13:52:29.331: e/androidruntime(17708): @ android.app.activitythread.handlelaunchactivity(activitythread.java:2127) 03-22 13:52:29.331: e/androidruntime(17708): @ android.app.activitythread.access$600(activitythread.java:140) 03-22...
Read more

actionscript 3 - Equivalent to moveReceived in ElectroServer 5 -

-
i working on proprietary game project , updating legacy code actionscript 1 actionscript 3. in particular, lot of game code previous iteration implemented using electroserver api method movereceived. api provides following description method: movereceived: availability flash player 6. usage electroserver.movereceived(type,object,from) parameters type either "public" or "private" (object) object object sent (object) from name of user sent move (object) returns nothing. description event fired when move received. can send , receive actual actionscript objects using sendmove , moverecieved. makes creating multiplayer games simpler. example the following example of move seen in game characters can jump , shoot. function movereceived(type:string, ob:object, from:string) { if (type == "private") { var action:string = ob.action; if (action == "shoot") { var x:number = ob.x; var y:number = ob.y; var ang...
Read more