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