Delete rows
Posted by janset on December 11, 2001 5:33 AM
A have a column which contains dates in it. Dates are repeated. If same date repeated more than 3 times I want to delete rest of it. Is there any easy way to do that. Thanks for the help
Posted by Juan Pablo G. on December 11, 2001 6:20 AM
Make another column an put this formula
=COUNTIF(A:A,A2)
If column A is the one whith the dates.
Now, autofilter and choose this new column and filter those that are > 3 and delete the "excess" rows.
Juan Pablo G.
