Identifying Dups in different ranges

[nrage21]

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 -

 

[Barb Reinhardt]

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