• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Remove Data which is not match with other column

dingdang

dingdang

Member
Hi,


I am downloading data from 2 different system in to xls and need to remove invoice no and amount which is not match with other data.


attached file for your ref.


https://dl.dropbox.com/u/66400357/diff.xlsx


A and B data from one system and D and E data from another system, currently i am doing foll. manually step to remove data.


sort A , B and D,E data in assending order, in C column applying formula A3-D3 and copying to the end and whenere there is diffence removing each Invoice no and amount from both data which is very time consuming process as data is almost 15000 to 18000.


Pls help if there is any other formula / macro to remove data which is not match
 
Hi dingdang,


I am not sure if I got the requirement correctly. But here is my blind shoot..


(For the first data set ranges from A to E) At F3 write the following formula:


=VLOOKUP(A3,$D$3:$D$151,1,0)


Wherever you do not have any match, formula will throgh # N/A


Put some heading at F2, filter col F by #N/A and then delete the rows.


Please post back if this is not something that you are looking for.


Kaushik
 
You must log in or register to reply here.
Back
Top