How to compare the contents of two rows is the same?

[OKLover]

Hi, All

Is any trick or tip could compare the contents of two entire rows is the
same?

 

[Anne Troy]

Hi, OKLover. Try this:
http://www.officearticles.com/excel/dealing_with_duplicate_records_in_microsoft_excel.htm
See the second formula under Finding With a Formula. You can use all the
columns you want by stringing them together, like B2&C2&D2&E2....

*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com

 

[Norman Jones]

Hi OKLover,

Assume that the rows to compare are row1 and row3, then in a cell elswhere
(not in rows 1 or 3) enter the formula:

=AND(1:1=3:3)

This is an array formula, so it needs to be confirmed with
Ctrl-Shift-Enter.

 

[OKLover]

Norman! you are my hero ~ Many Thanks

But if the two rows on different worksheet, how to deal with?

 

[Norman Jones]

Hi OKLover,

To compare row1 on sheet1 with row3 on sheet2, try:

=AND(Sheet1!1:1=Sheet2!3:3)

 

[Tom Ogilvy]

Rarely have I seen all the cells in a row filled with data. Perhaps you
could refine your request. Also, are you looking for a VBA or a worksheet
function solution (or a VBA UDF used in a worksheet).

You can also look here:

http://www.cpearson.com/excel/duplicat.htm