Forum Discussion
Deleting specific rows
Hi, I created a column with dates from January 1st till years later. As I only want to see the Mondays, Wednesdays and Fridays is there any formula I could use to delete the other rows? Thanks for an...
Let's say your dates are in A2 and down.
In another column, enter the following formula in row 2:
=WEEKDAY(A2)
(In Dutch: WEEKDAG)
Then fill down.
Turn on Filter.
Click the dropdown arrow in the new column, and clear the check boxes for 2, 4 and 6, then click OK.
You now see only the rows for Sunday, Tuesday, Thursday and Saturday.
Delete all those rows in one go.
Finally, remove the filter.
Only the rows for Monday, Wednesday and Friday remain.