Identifying Dups in different ranges
 

I have a workbook with at least 1500 rows filled with info. I want to
mark rows that are duplicates based on information on three columns
(A,B,E). For example

A B C
D E
06/20/2005 802676955 MTAB&T - 0:00:00 TBM 12:21:01

I try to use: =IF(COUNTIF(Range1,$E5)1,"Duplicate","")

But the above worksheet function is inappropiate as it only look for
dups based on column E. Can someone help me, by providing or
formulating a formula that will help me get the desired results and
include columns A,B, and E into the criteria?.

TIA

- Larry -


--
nrage21
------------------------------------------------------------------------
nrage21's Profile: http://www.excelforum.com/member.php...fo&userid=4808
View this thread: http://www.excelforum.com/showthread...hreadid=444338

I'd probably concatenate the data in column A-E into one cell in Column F.
(assuming it handles the width)

Use Conditional formatting to highlight duplicate cells in column F.

http://www.contextures.com/xlCondFormat03.html

"nrage21" wrote in
message ...

I have a workbook with at least 1500 rows filled with info. I want to
mark rows that are duplicates based on information on three columns
(A,B,E). For example

A B C
D E
06/20/2005 802676955 MTAB&T - 0:00:00 TBM 12:21:01

I try to use: =IF(COUNTIF(Range1,$E5)1,"Duplicate","")

But the above worksheet function is inappropiate as it only look for
dups based on column E. Can someone help me, by providing or
formulating a formula that will help me get the desired results and
include columns A,B, and E into the criteria?.

TIA

- Larry -


--
nrage21
------------------------------------------------------------------------
nrage21's Profile:
http://www.excelforum.com/member.php...fo&userid=4808
View this thread: http://www.excelforum.com/showthread...hreadid=444338