Search : in
By :

Compare columns and return true or false

Last answer on Aug 7, 2009 2:23:36 am BST Div, on Aug 6, 2009 11:07:15 pm BST 
 Report this message to moderators

Hello,
i have two columns with job numbers, that I would like to compare. If the numbers in Column A matches with Column B then I would like to get the value "TRUE" in column C if not then "FALSE". I used IF formula to get that but it is not working.

Configuration: Windows XP
Firefox 3.0.13

Best answers for « compare columns and return true or false » in :
Excel - Comparing columns and returning value Show Excel - Comparing columns and returning value Issue Solution Note Issue I have an Excel spreadsheet where I want to compare values between two columns and return the value from another column. EX: Column: A B C D ...
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...
Excel - IF formulas for Printing and Calculation ShowExcel - IF formulas for Printing and Calculation Issue Solution Note Issue I am trying to get Excel IF formulas to print a text and calculation based on true/false. Such as, if I have some dates, and I don’t need to send a notice to a...
Download TrueTransparency ShowThe personalization of the appearance of Windows XP became commonplace. Since his launching, several editors threw different topics to change the mode of billing of XP. True Transparency is a program allowing to change only the appearance of the...

1

 venkat1926, on Aug 7, 2009 2:23:36 am BST

If the ample data is like this in coluns A and B from row no 1 daown

a a
s w
d d
f r


in C1 copy paste this formula
=IF(A1=B1,"true","false")
and then copy C1 down

Reply to venkat1926