'Yes' or 'No' on two columns

rhyspippard

New Member
Joined
May 5, 2005
Messages
32
I have two columns of numbers. Some lines are identical and some are different. In a third field, I need to use a formula which flags by either 'yes' or 'no' whether each line in the two columns are identical.

Please forgive what must be a very simple query. Your help is, as always, much appreciated.
 

Some videos you may like

Excel Facts

Excel motto
Not everything I do at work revolves around Excel. Only the fun parts.

MichaelRo

Well-known Member
Joined
Jun 7, 2004
Messages
549
Assuming Column 1 is A and Column 2 is B - Copy the following formula into Column 3 (C):

=IF(A1=B1,"YES","NO")
 

Watch MrExcel Video

Forum statistics

Threads
1,118,670
Messages
5,573,558
Members
412,537
Latest member
Mohamed_5966
Top