Color

this problem have has been bother , nice if possible. have list of numbers (1-58) (a6:a63) , next them list of names (b6:b63) need formula in cell e4 , looks cells in range a6:a63 match cell e3, once found display in cell next cell matched e3. need work e3:bj3 way can see use if function. =if(e$3=1,"a",if(e$3=2,"b",if(e$3=3,"c",etc))) there easier way? have pictures here : http://imgur.com/a/nj4h9 try this: e4=index($b$6:$b$63,match(e3,$a$6:$a$63,0)) or this e4=vlookup(e3,$a$6:$b$63,2,0) then copy e5 , right.

i fed problem , not finding solution. the problem trying test website using test automation in c#. need sign in, sign-in button not button, it's span tag property set 'role=button' . i using selenium chrome web driver , using unit extensions automate test. problem whenever run test in test explorer click event performed, page not navigate next page, , nothing happens. however, when set break point , run same test through main function works fine. i have set break point perform click operation , perform login operation. i using visual studio console application. here pic of web site html tag . the problem click function not loaded @ time run test "quick", when debug. try load page. wait 1 second. getelement , click it. normal in pages add javascript function elements dynamically.

i have researched problem lot can't seem result. trying insert new values , query tables django established table-database. seems number of people have had reoccurring problem on years. have tried rectify both on mac , on desk linux server both on django 1.8 , 1.9 problem remains after migrations... based on advice have seen on similar posts have tried following: # update database establish inputs ./manage.py # inserting installed_apps django.contrib.sites # modifying settings.py below... import os project_path = os.path.dirname(os.path.abspath(__file__)) 'name': os.path.join(project_path,'mysite.sqlite3'), # specifying full pathname database in settings.py 'name': os.path.join(base_dir, '/project/homemsc/username/trydjango19/mysite/db.sqlite3') however in case of each of these modifications when inserting values in sqlite "error: no such table exists" returned. know...

i want put page modal-slide up,that keeps menu bar static (as in, when modal opens, menu/top bar not slide up). the modal slide's up- nav-bar/menu bar should white. space created (with class="has-header") white. by clicking on magnify glass, modal activated on site- click here . unsuccessfully tried making plunker ( here ). here code: to open modal (in .html) <i class="ion-ios-search-strong" ng-click="refineevent()"></i> part of js $ionicmodal.fromtemplateurl('app/components/stores/stores.html', { scope: $scope, animation: 'slide-in-up' }).then(function(modal){$scope.modal = modal;}); $scope.refineevent = function(){$scope.modal.show();}; $scope.closemodal = function(){$scope.modal.hide();}; $scope.$on('modal.shown', function(){console.log('modal shown!');}); } and modal.html file: <ion-modal-view> <ion-view name="stores"><ion-pane ng-controll...

i writing cython extension use in python. i have cython declaration .pxd file declares c struct defined in other c header file: # cython definitions parameters.h cdef extern "parameters.h": ctypedef struct control_par: int num_cams # other struct fields.... now want same thing other header file here have use defined above: control_par c struct in cython .pxd file: from optv cimport parameters, calibration # no error here during setup cdef extern "optv/trafo.h": void pixel_to_metric(# other parameters... control_par * parameters); during cythonizing error: 'control_par' not type identifier like not defined @ all. what doing wrong? the correct way import c definitions parameters.control_par . do: from optv.parameters cimport control_par, whatever_else_you_need

i thinking of app represents store, using gridview view items , data represented observablecollection. my xaml code : xmlns:data="using:itemsstore.models" <gridview itemssource="{x:bind itemslist}"> <gridview.itemtemplate> <datatemplate x:datatype="data:item"> <stackpanel orientation="vertical"> <image source="{x:bind imagesource}"/> <textblock text="{x:bind name}"/> <textblock text="{x:bind disc}"/> </stackpanel> </datatemplate> </gridview.itemtemplate> </gridview> the c# code in mainpage : public sealed partial class mainpage : page { public observablecollection<item> itemslist; public mainpage() { this.initializecomponent(); itemslist...

so have activity inflates gridview, , want clickable, , upon click, opens new activity, shows whole image, along texts i've written in activity. note confirmed txt file written written successfully, , in sd card. here code gridview activity public class gridview extends appcompatactivity { android.widget.gridview gv; arraylist<file> list,list2; @override protected void oncreate(@nullable bundle savedinstancestate) { super.oncreate(savedinstancestate); setcontentview(r.layout.gallery); file dir = new file(environment.getexternalstoragedirectory().getabsolutepath() + "/mycameraapp"); file dir2 = new file(environment.getexternalstoragedirectory().getabsolutepath() + "/mycameraapp"); list = imagereader(dir); list2 = locationreader(dir2); gv = (android.widget.gridview) findviewbyid(r.id.gridview); gv.setadapter(new gridadapter()); gv.setonitemclicklistener(new adapterview.onitemclicklistener() { @overrid...