excel - Loop to search and print unique value from range -


i have list of values, , in table, have same values spread out.

i need sort of loop can search 1x20 list , print first value not in table, without having write numerous countif() statements. there way faster?

sure need loop of range of cells , test if value exists. you'd need post more of code give specific example should started:

sub loopexampleusingrange()  dim acell range each acell in activesheet.range("a1:a20").cells  if instr(1, "some text/table/or cell value s", acell.value)     'if exists put here     'perhaps nothing?  else     'if doesn't exist put code here.  end if   next acell  end sub 

Comments

Popular posts from this blog

php - Vagrant up error - Uncaught Reflection Exception: Class DOMDocument does not exist -

vue.js - Create hooks for automated testing -

Add new key value to json node in java -