excel 2007 - a cell containing the same value of another cell in column -

- 

p12100600006    p12100100000    p12100600000    121006 p12100600006    p12100100000    p12100600000    121006 m12200100012    p12100400000    p12110100001    121101 p12200700000    p12100400000    p12100600000    121006 m12200100012    p12100400000    p12110200016    121102 m12200100012    p12100500000    p12100100000    121001 m12200100012    p12100600000    p12100500000    121005 p12200700000    p12200100000    p12200700000    122007 p12200700000    p12200100000    p12200700000    122007 p12200700000    p12200100000    p12200700000    122007 p12200700000    p12200100000    p12200700000    122007 p12200700000    p12200100000    p12200700000    122007 p12200700000    p12200100000    p12200700000    122007 p12200700000    p12200100000    p12200700000    122007 m12200100012    p12200100000    p12200600000    122006 p12200100001    p12200200000    p12200400004    122004 r12200100000    p12200400000    p12205200000    122052 r12200100000    p12200400000    p12205200000    122052 r12200100000    p12200400000    p12205200000    122052 p12200500000    p12200400000    p12200700000    122007 p12200100000    p12200700000    p12200100000    122001

in above given data want if a1 contains value in d1 respectively a2 contains d2 , on. in excel example in last row column p12200100000 having value of d columns value 122001

otherwise find if first 7 element of column , column c same 

=iferror(find(d1,a1),left(a1,7)=left(c1,7))

copied down should give numeric result if in same row (starting @ 1) value in columna contains value in columnd. otherwise, if first 7 characters of columna same first 7 characters of columnc of same row result should true. if neither of these result should false.

but others, not whether requirement, how think can interpreted.


Comments

Post a Comment

Popular posts from this blog

javascript - Count length of each class -

-
i have below code in this fiddle . html <span class="myname">john smith</span> <span class="myname">john smith</span> <span class="myname">john smith</span> <span class="myname">john smith</span> <span class="myname">john smith</span> <span class="myname">john smith</span> javascript $('.myname').each(function(){ var text = $(this).html().split(' '), len = text.length, test = $(this).val().length, result = []; console.log('outside: ' + test); for( var = 0; < len; i++ ) { result[i] = '<span class="name-'+[i]+'" >' + text[i] + '</span>'; console.log('inside: ' + test); } $(this).html(result.join(' ')); console.log('after
Read more

What design pattern is this code in Javascript? -

-
this question has answer here: why write “.call(this)” @ end of javascript anonymous function? [duplicate] 4 answers what kind of design pattern , significance of using closure? (function(){ // code here }).call(this); edit then difference between above code , following this keyword still refer same object in both ways. (function(){ // code here })(); thats invoked function expression. more info here: http://benalman.com/news/2010/11/immediately-invoked-function-expression/ the purpose run code while protecting scope (so variables declared within don't leak out global scope. update call sets value of this function being applied on. without it, value set window object, there set outer scope.
Read more

hadoop - Restrict secondarynamenode to be installed and run on any other node in the cluster -

-
i have have cloudera cdh3u4 cluster setup. have secondarynamenode daemon running on 1 of nodes. i have ensure user has root access node on cluster (for example, datanode not have other daemons running) should not able start instance of secondarynamenode daemon on node (thereby having 2 secondarynamenodes on cluster) how can achieve this? thanks in advance. add property hdfs-site.xml namedfs.secondary.http.address valuesecondarynamenode-host address or ip:50090
Read more