excel - Searching occurrence of custom codes in data set -


i tying accomplish following in microsoft excel through vba. use help!

i have 2 sets of data: data dump & key containing codes (each of contains list of strings).

the objective search data dump & assign true/false & count value each code in our key in accordance whether code found in data dump or not & if found, how many times occurred, case may be.

we can code found in data dump when each of strings of particular code found in data dump.

providing sample eg. below clarify whole problem:

let's have key containing following codes each of comprises of multiple string values:

usa: ford, ferrari, chevrolet

india: maruti, modern, hero

korea: kia, hyundai, daewoo

japan: honda, yamaha, suzuka

germany: bmw, mercedes, audi

now, in given data dump, want count how many times each of usa, india, korea, japan, germany occur. each of usa's "occurrence", each of ford, ferrari, chevrolet need found once in dump. if these values found 4 times each, usa said occur 4 times in dump. if ford found 5 times, ferrari 3 times & chevrolet 2 times, usa have 2 occurrences.

similarly, each of japan's "occurrence", each of honda, yamaha & suzuka need found once.

likewise others.


-

Comments

Post a Comment

Popular posts from this blog

angular - Is it possible to get native element for formControl? -

i've got angular2 reactive form . created formcontrol s , assigned input fields by [formcontrol]=... . understand creates nativeelement <-> formcontrol link. my question: possible nativeelement formcontrol ? wanna myformcontrol.nativeelement.focus() i can share 1 terrible solution works me. in reactive forms can use either 1) formcontroldirective ts mycontrol = new formcontrol('') template <input type="text" [formcontrol]="mycontrol"> or 2) formcontrolname ts myform: formgroup; constructor(private fb: formbuilder) {} ngoninit() { this.myform = this.fb.group({ foo: '' }); } template <form [formgroup]="myform"> <input type="text" formcontrolname="foo"> </form> so these directives write patch like 1) formcontroldirective const originformcontrolngonchanges = formcontroldirective.prototype.ngonchanges; formcontroldirective.proto
Read more

unity3d - Rotate an object to face an opposite direction -

i have object , b. when click on object b, rotates object b (a faces b). b doesn't face a. need following : when faces b, need face opposite direction. have code rotating @ b. how rotate face opposite direction after that? vector3 targetdirection = target - transform.position; float step = speed * time.deltatime; vector3 newdirection = vector3.rotatetowards (turretdome.transform.forward, targetdirection, step, 0.0f); turretdome.transform.rotation = quaternion.lookrotation (newdirection); you object facing object b, want inverse direction of object after that? objecta.transform.rotation = quaternion.inverse(objecta.transform.rotation) but lets assume example turretdome object a, (negate direction): turretdome.transform.rotation = quaternion.lookrotation (-newdirection); naturally, both of these snippets not show how smoothen rotation, seem know how use time.deltatime. just incase unsure, quaternion.lerp this
Read more

javascript - Why jQuery Select box change event is now working? -

i working on product filters user select select box according his/her preference not getting selected value user in jquery. html code:- <select name="product_filter" id="product_filter"> <option value="price_low_first">price : low high</option> <option value="price_high_first">price : high low</option> <option value="latest">latest</option> <option value="popular">most popular</option> </select> jquery code: $(function () { $("#product_filter").change(function () { alert("hi") var selectedtext = $(this).find("option:selected").text(); var selectedvalue = $(this).val(); alert("selected text: " + selectedtext + " value: " + selectedvalue); }); }); hi believe code perfect. once please check jquery.min.js
Read more