Excel VBA to find non unique values with multiple conditions -

-

i looking trying create excel macro. have large sheet bit this:

account name  address dealer 68687   sara  11 wood 1111 68687   sara  11 wood 1111 68687   sara  11 wood 1111 12345   tom   10 main 7878 12345   tom   10 main 7878 54321   tom   10 main 7878 10101   john  25 lake 3232 10101         25 lake 3232 11111   john  25 lake 3232

what need highlight rows on sheet each dealer has more 1 unique value in account column, must have value in name column. in above example want highlight rows dealer 7878.

i not if should @ loops or arrays, might take long time sheet quite large.

looking help.

thanks.

james - dirk gave answer in comment. looks ...

enter image description here

the format formula put column f, can see results of calculation.

if feel should still have vba solution, gives starting point how layout code ...

  1. ignore rows empty name
  2. count rows dealer same dealer in current row, , account not same account in current row
  3. if count found in step 2 greater 0, highlight current row.

Comments

Post a Comment

Popular posts from this blog

html - Styling progress bar with inline style -

-
i trying set progress bar color red using inline style. need in way because have access <body> part of document. style need apply: progress { color: red } progress::-moz-progress-bar { background: red;} progress::-webkit-progress-value { background: red; } progress[aria-valuenow]:before { background: red; } i tried <progress style="background: red;"> incorrect effect, progress bar color turns blue red background. guide right direction desired style? thank in advance. here live example: https://jsfiddle.net/z36d3f6l/
Read more

java - Oracle Sql developer error: could not install some modules -

-
i have downloaded fresh copy of sqldeveloper ( sqldeveloper-4.1.3.20.78-no-jre ) oracle website. when unzip , lauch gui, keep getting following error message: warning - not install modules: dynamic module config - no module providing capability org.netbeans.netbinox found. my system: windows 7 32 bit hp probook. jdk 1.6 , 1.7, 1.8 available in java/jdk subdirectory. netbeans 8.0.2 installed finally got way out after dirty hours. extracted sqldeveloper zip in nested directory. i.e: e://a/b/c/sqldeveloper. starting sqldeveloper gui above directory threw erros. solution: go in c:\users**username**\appdata\roaming : delete sql developer , sqldeveloper folders extract sql developer zip in new non nested directory. i.e: e:// start , should work now reference: https://community.oracle.com/thread/3870680?start=0&tstart=0
Read more

How to use autoclose brackets in Jupyter notebook? -

-
this may sound silly question, how make use of autoclose brackets in jupyter notebook? example, when type print( jupyter notebook auto-closes brakets print() and places cursor inside. type argument, say print(1 + 1) now cursor between second 1 , right bracket ) . key navigate right of ) ? of course can press end or → or ) achieve this, not seem save time, purpose of brackets autoclose suppose? thanks in advance.
Read more