Search : in
By :

How to compare two coloumns in excel

Last answer on Nov 10, 2009 8:03:35 am GMT vijay, on Apr 11, 2009 3:13:34 pm BST 
 Report this message to moderators

Hello,

Configuration: Windows XP
Internet Explorer 6.0

Best answers for « how to compare two coloumns in excel » in :
Comparing the contents of two folders ShowComparing the contents of two folders Under XP, it is possible to integrate a function that allows you to compare the contents of two folders. This may be useful when dealing with folders containing a lot of files and that you...
Excel – Comparing cell A1 to entire A column in Sheet 2 ShowExcel – Comparing cell A1 to entire A column in Sheet 2 Issue Solution Note Issue I have been trying to compare sheet1 A2 to sheet2 A2 through A500 and if it exists somewhere in sheet2's a col then copy that entire row to a new sheet....
Basic Excel Formulas 2 ShowBasic Excel Formulas 2 We saw the SI function Function and is also interesting. Combined with SI, this gives: = IF (AND (condition1; condition2 ;....... conditionZ) true false) displays on the various conditions to be verified (eg...
Spreadsheets - The Excel Interface ShowExcel Introduction Microsoft Excel is the spreadsheet in the Microsoft Office office suite. To start it, simply click on the appropriate icon in the Start menu (in Windows) or click on an Excel file (that has an .xls file extension). A Excel...
PS/2 connector ShowPS/2 connector The PS/2 connector (mini-DIN6 format) is mainly used to connect computers to keyboards and mice. Pins Pin number Function 1 Clock 2 Ground 3 Data 4 Ground (or not...
Ask your question Reply

1

Excelguru, on Apr 12, 2009 11:25:45 am BST
  • +1

In a new column, put =cell1=cell2 and drag this to the end Eg Two compare column1 & column2, in cell(A3) put '=A1=A2' If both the values are same, TRUE will be displayed. To find FALSE search for FALSE

   
Reply to Excelguru

2

 Sri, on Nov 10, 2009 8:03:35 am GMT

Same thing if I have to compare three columns what to do ?

   
Reply to Sri
Ask your question Reply
They need your help