EXCEL MASS DELETE 2

[Acowaz]

Excel question: I have used the formula in a database =if(d1-d2, 0, 1). I am able to view the duplicates because they are 0's but is there a way to do a mass deletion. But is it possible for it to delete the entire row based upon the zero. The database contains over 10,000 items therefore, deleting zero by zero is quite time consuming. Thanks in advance.

Al

 

[carrr]

Try the conditional row delete add-in available at John Walkenbach's site:

http://www.j-walk.com/ss/excel/files/rowdel.htm

 

[luceze]

You could auto filter on the zero, select the filtered rows and delete.

HTH,
Eric

 

[Acowaz]

Thanks to Carrr & Eric. J-walk is more automated than filtering but both got the job done. Thanks again!