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

Hi, All

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

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

Hi, OKLover. Try this:
http://www.officearticles.com/excel/...ft_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


"OKLover" wrote in message
...
Hi, All

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

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

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.


---
Regards,
Norman



"OKLover" wrote in message
...
Hi, All

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

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

Norman! you are my hero ~ Many Thanks :D

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




"Norman Jones" bl...
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.


---
Regards,
Norman



"OKLover" wrote in message
...
Hi, All

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

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

Hi OKLover,

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

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


---
Regards,
Norman



"OKLover" wrote in message
...

Norman! you are my hero ~ Many Thanks :D

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




"Norman Jones"
bl...
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.


---
Regards,
Norman



"OKLover" wrote in message
...
Hi, All

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

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

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 he

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

--
Regards,
Tom Ogilvy


"OKLover" wrote in message
...
Hi, All

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