excel - Compare two list of values A and B, if there any value equal to B in the list A -


how compare 2 list of values a , b, if there value in b equals value in list a, write row number of column a in front of value in column b using excel/macro/vba.

use vba:

sub test()     dim ws worksheet     dim long, j long, k long     dim strvalueb string, strvaluea string      set ws = activesheet              = + 1: j = 0         strvalueb = ws.cells(i, 2).value    '2 -> column b         if (strvalueb = "") exit                      j = j + 1             strvaluea = ws.cells(j, 1).value    '1 -> column             if (strvaluea = "")                 k = 0                 exit             elseif (strvalueb = strvaluea)                 k = j                 exit             end if         loop          if (k > 0)             ws.cells(i, 3).value = k    '3-> column c         end if     loop end sub

Comments

Post a Comment

Popular posts from this blog

IF statement in MySQL trigger -

this query code in mysql trigger. if 1=2 select 'yes'; else select 'no'; end if; but has following error: if '1'='2' select 'yes' error code: 1064. have error in sql syntax; check manual corresponds mysql server version right syntax use near 'if '1'='2' select 'yes'' @ line 1 0.000 sec what solution?
Read more

c++ - What does MSC in "// appease MSC" comments mean? -

i run across // appease msc in c++ comments, e.g. here : const int& array::operator[](int offset) const { int mysize = getitssize(); if (offset >= 0 && offset < getitssize()) return ptype[offset]; throw xboundary(); return ptype[offset]; // appease msc! } what msc stand ? the author means microsoft's compiler, more formally known msvc.
Read more

android - MPAndroidChart - How to add Annotations or images to the chart -

i working latest mpandroidchart library , looking way add annotations or images clickable. example: once data reaches value event occurs want able display user - there multiple events can occur annotations (not sure if right word) or image added @ point in chart. any pointers welcome. check documentation of yaxis . focus on setspacetop(...) , setaxismaxvalue(...) methods. for background: bar-shadow , disable calling: barchart.setdrawbarshadow(false) or change color: bardataset.setbarshadowcolor(int color)
Read more