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

Adjustable DC to DC step up voltage booster using LM2577 -Adj P+ chip

One simple circuit to step up voltage using LM2577 -Adj P+ chip. The schematic is from Texas Instrument and it works expected - and below is...