Is there a best way to filter or clean data either in rows or columns based on multiple conditions. Attached is sample data set I need to clean based on as of date (Eg: 04/02/2016). I need to keep data for registered weeks that are fully complete and truncate any data in reg data column for partially completed and not completed weeks if any exists.
Please suggest. Thank you in advance