#1
|
|||
|
|||
How to compare 2 columns with other two columns in EXECL 2007?
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. |
#2
|
||||
|
||||
What kind of data is it, and what kind of result do you expect?
|
#3
|
|||
|
|||
Quote:
Regards. |
#4
|
||||
|
||||
Please post a sample spreadsheet.
|
#5
|
|||
|
|||
Please find attached the spread sheet.
Thanks. |
#6
|
|||
|
|||
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 |