Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
formula -too slow
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
formula -too slow
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Why is excel 2007 slow when selecting chart data from the formula | Charts and Charting in Excel | |||
Slow Excel Navigation with Up / Down Arrow and slow scrolling | Excel Discussion (Misc queries) | |||
Why so slow | Excel Discussion (Misc queries) | |||
Formula Arrays VERY SLOW in Excel 2002 | Excel Worksheet Functions | |||
sumproduct formula to slow | Excel Worksheet Functions |