compare data

[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...

 

[Norman Harker]

Hi Singkit!

Take a look at:

Chip Pearson:
http://www.cpearson.com/excel/duplicat.htm#HighlightingDuplicates
All sorts of formulas for handling duplicate / unique problems

--
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.

 

[Frank Kabel]

Hi
have a look at
http://www.cpearson.com/excel/duplicat.htm#ExtractingCommon

 

[singkit]

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

 

[Norman Harker]

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.