excel - How to sort values in column to match with another column VBA? -


list item

hi i'm trying figure out how can sort column b in order values in matches of column , delete values in column b not in column a. i'd leave cells empty in column b when values not match of column a. can me codes please? thanks!!!

a 132 43 345 35 654 84 26 54 635

b 132 43 24 345 67 35 84 26 79 54

if wish compare each row in column , b, open new column c , enter first line:

=if(a1=b1,a1,””) 

drag down .this should fixed column b. can paste special values (instead of formulas) , erase true column b afterwards. if values unique each column , want make sure value in column found on column b no rows relation: open new c , enter on c1:

=ifna(vlookup(a1,b:b,1,0),””) 

same goes here drag, paste , erase.


Comments

Popular posts from this blog

java - UnknownEntityTypeException: Unable to locate persister (Hibernate 5.0) -

python - ValueError: empty vocabulary; perhaps the documents only contain stop words -

ubuntu - collect2: fatal error: ld terminated with signal 9 [Killed] -