Tuesday, May 26, 2015

How to compare 2 different column to check if it is exact match or not in excel or google spreadsheet

This Formula work for Microsoft Excel and Google Spreadsheet

=IF(C661=H661,1,0)

In this example

C661 = Cell from column A
H661 = Cell from colum B
1 = Defined if there is match
0 = Defined if no match

No comments:

Post a Comment

Related Posts Plugin for WordPress, Blogger...