If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Compare 2 columns in a worksheet.
Hi,
I need to compare 2 columns in a worksheet and see if the values are similar. Eg: A : B X-001 X-001 X-024 X-024 x-090 X-089 X-334 X-334 X-323 X-323 The third row must be highlighted here because the value is different in the 2 columns. Is there any Excel function to compare 2 columns? Can someone tell me how to do this. Thanks, Neeraja |
#2
|
|||
|
|||
Compare 2 columns in a worksheet.
Neeraja, here is one way =A1=B1 put this in C1 and copy down, will retrun
true if the cell are the same or false if the cells are different -- Paul B Always backup your data before trying something new Using Excel 2000 & 97 Please post any response to the newsgroups so others can benefit from it ** remove news from my email address to reply by email ** "Neeraja" wrote in message ... Hi, I need to compare 2 columns in a worksheet and see if the values are similar. Eg: A : B X-001 X-001 X-024 X-024 x-090 X-089 X-334 X-334 X-323 X-323 The third row must be highlighted here because the value is different in the 2 columns. Is there any Excel function to compare 2 columns? Can someone tell me how to do this. Thanks, Neeraja |
#3
|
|||
|
|||
Compare 2 columns in a worksheet.
Select the cells that might need to be highlighted. Then select
Format-Conditional Formating. Change "Cell value is" to "Formula is", enter this formula: =$A1$B1 click format, and select a pattern to shade the cells. -Dave "Neeraja" wrote in message ... Hi, I need to compare 2 columns in a worksheet and see if the values are similar. Eg: A : B X-001 X-001 X-024 X-024 x-090 X-089 X-334 X-334 X-323 X-323 The third row must be highlighted here because the value is different in the 2 columns. Is there any Excel function to compare 2 columns? Can someone tell me how to do this. Thanks, Neeraja |
Thread Tools | |
Display Modes | |
|
|