You can use almost the same formula to do it, if it is sorted by rep then
=IF(A1=A2,1,"") this will put a 1 in all dupes, copy paste special values the
whole column, then sort and delete all of the rows with a 1.
--
-John
Please rate when your question is answered to help us and others know what
is helpful.


"Wanna Learn" wrote:

Hello I have Excel 2002
I have a report that is imported from another system
col A has the name of the rep, col B has the ID no., col C has the order
type
and col D has the number of calls received for the order type
in column E I have this formula =IF(A1=A2,D1+D2,"0")
Then I go back and delete the row that has the duplicate name

Problem
Is there a faster way to do this, ? Sometimes the report has over 500 lines
and it takes a while to delete the rows thanks in advance