How to compare 2 columns with other two columns in EXECL 2007?

Learner7 · #1 06-03-2010, 12:35 AM

Hi,

I have four columns in a excel sheet. I would like to compare the data of first two columns (Column 1 & Column 2) with the next two columns (Column 3 & Column 4). After comparing the data, the result (difference) should be shown in Column 5 & Column 6.

Please do help me in this regard.

Thanks in advance.

ConneXionLost · #2 06-03-2010, 08:57 AM

What kind of data is it, and what kind of result do you expect?

Learner7 · #3 06-05-2010, 02:05 AM

Quote:

Originally Posted by ConneXionLost

What kind of data is it, and what kind of result do you expect?

I have text in all four columns. Now, What I need is, whatever the data in 1st & 2nd column available but not in 3rd & 4th column should be shown in 5th & 6th Column.

Regards.

ConneXionLost · #4 06-05-2010, 02:05 PM

Please post a sample spreadsheet.

Learner7 · #5 06-12-2010, 09:52 AM

Quote:

Originally Posted by ConneXionLost

Please post a sample spreadsheet.

Please find attached the spread sheet.

Thanks.

Learner7 · #6 06-12-2010, 09:54 AM

Quote:

Originally Posted by Learner7

Please find attached the spread sheet.

Thanks.

Please also see the snapshot of my excel file.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Footnotes and Columns	toll_booth	Word	0	06-02-2010 01:35 PM
Independent columns	jdthelen	Word	2	09-17-2009 09:34 PM
Compare data in different columns in an Excel sheet	kgfendi	Excel	5	05-16-2009 05:42 PM
Re Formatting Columns?	erikjen	Word	0	02-16-2009 12:25 AM
How do i get my text in columns straight and inline in word 2007?	terrasaw	Word	0	09-03-2008 06:00 AM