compare data

  • Thread starter Thread starter singkit
  • Start date Start date
S

singkit

Hello there!!!

I need to compare column A and B if row 1,2,.....
have the same records and the answer is true or false at
column C. What is the formula for that.

Your help is greatly appreciated.

THANKS!!!More power...
 
Sorry! I'm not good in creating formula. Can you please
provide me one.
example

A B C
1 32 false
123 123 true
25 25 true
456 457 false

What will be the formula in column C to have it true or
false answer.

THanks
 
Hi Singkit!

With your data the formula you need is reasonably easy:

=IF(A1=B1,TRUE,FALSE)

You can shorten it to:

=IF(A1=B1,TRUE)

Or even shorter to:

=A1=B1

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Back
Top