excel - Countifs and Partial Matching -


here code partially working{=if(cg!d:d="*"&homeports!b16:b42&"*"<>0,countifs(cg!c:c,"*marmc*",cg!h:h,"*tech*"),0)}

my result should count cells contain marmc , tech, count them if columns cg!d:d , homeports!b16:b42 match.... partially. example: cell in column cg!d:d has word **uss new york (lpd)** while cell in column homeports!b16:b42 has word **uss new york**

without adding numerous countifs(cg!c:c,"<>*whatever*) exclude cells words don't want count.


Comments

Post a Comment

Popular posts from this blog

'hasOwnProperty' in javascript -

i use obj.hasownproperty judge whether object has property, when replaced obj[prop] !== undefined , not normal implementation, ask, why behind method can not use it? object.hasownproperty(prop); object[prop] !== undefined; obj[prop] !== undefined wrong 2 reasons: you can explicitly set property undefined , obj[prop] = undefined; . obj.hasownproperty(prop) return true in case. obj[prop] follow prototype chain, return property that's inherited. obj.hasownproperty(prop) returns true if property exists directly in object, returns false inherited properties.
Read more

How to put a lock and transaction on table using spring 4 or above using jdbcTemplate and annotations like @Transactional? -

i trying put lock on table while writing on table , if happened in between roll-back . trying convert below code lock table test_g1 read; lock table test_g write; -- begin; start transaction; insert test_g1 values(143); insert test_g values(145); select * test_g1; select * test_g; rollback; select * test_g; unlock tables; how convert above code @transactional spring jdbctemplate code? @transactional(rollbackfor={dataaccessexception.class}) public void test(){ jdbctemplate.execute("insert test1 (id, nam) values (4, 'a')"); throw new dataaccessexception("error") { }; } here trying throw error, insert statement should rollback it's not happening . thanks edit-1 attaching code , doing in jdbcdaoimpl.java , mentioned problem comment above test() . app.java package com.cgiri.javabrains.spring4; import org.springframework.beans.factory.annotation.autowired; import org.springframework.context.applic...
Read more

java - How to implement an entity bound odata action in olingo v4.3 -

similar post, i'm trying implement action bound entity how create bounded action in olingo v4 (java) but 500 no error logged when metadata document. in answer above linked question, there no mention of getactionimport() implementation described in olingo tutorial, , wonder if needs modified entity-bound action? how can olingo log error causing 500? getting debug output quite easy: handler.register(new defaultdebugsupport()); where handler odatahttphandler armed this, , after examination of olingo-server-core code, discovered: you don't need actionimport @ bound actions. the action name in url needs qualified namespace, https://issues.oasis-open.org/browse/odata-812 has not been implemented. when built client url using org.apache.olingo.client.api.uri.uribuilder , wrapped entity id in single quotes, , olingo server threw exception, reverted using stringbuilder
Read more