1.

Solve : Comparing Data - Ms Excel?

Answer»

Hello, I've got two separate worksheets as given bellow, I need to be able to compare the two columns and get result in sheet3 as given bellow.

SHEET 1:
Colum 1
AA
BB
CC
DD
EE
FF
GG
HH
II
JJ


Sheet 2:
Colum 1
AA
CC
FF
GG
II


But i want

Sheet 3:
BB
DD
EE
HH
JJ

Can this be done? It can be done but you need to be a little more specific about what you are TRYING to do. Can you elaborate on what data is GOING into each sheet?How can you compare 2 SHEETS that are different and have the results show up with the missing data ? ?

Or is it me that's missing something ? ?Quote

How can you compare 2 sheets that are different and have the results show up with the missing data ? ?

Or is it me that's missing something ? ?

I was thinking along the lines of if sheet 1 has aa,bb,cc etc in column 1 and in column 2 you type either Yes or No then it would be easy to seperate the data onto sheet 2 and 3 using the If command.


Discussion

No Comment Found

Related InterviewSolutions