Thread: [Solved] Finding the complements between the two data sets
View Single Post
 
Old 08-14-2009, 06:22 AM
psenku psenku is offline Windows XP Office 2007
Novice
  
Join Date: Aug 2009
Posts: 1
psenku is on a distinguished road
Default Finding the complements between the two data sets
Hi,
I am working on a data handling wherein i am required to find the values that are in column A but not present in column B. For example, if the column A has 1,2,3,4,5 and B has 1,3,5, i want to get the values 2,4 which are not present in the column B. i am dealing with million rows and finding it difficult the get the complement records. I am using MS Office 2003. Any help is greatly appreciated.

Regards,
Senthil
Reply With Quote