MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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.