I have attached dummy data here and I want to remove yellow highlighted data every time.
One thing about this data is it will not have any value from column F till column I.
Could someone help me in this? This is really urgent
@Meghnagupta IF the colum F will be empty for the records to be deleted then you can add a filter tool like below
Hi @Meghnagupta please see this thread, it seems to be exactly what you are after: https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Validating-and-filtering-excel...
@binuacs : It won't work this way because I need this filter when all the columns are blank. If I put this filter then it will be restricted to only one column nd which is not the case.
@Rhys_Cooper : I tried this thread but macro being used here is throwing an error and I am unable to configure that.
@Meghnaguptamay you share the exact error code please and I will look into it
@Meghnagupta Can you give a little bit more information about your requirement? my understanding is that you need to remove the highlighted rows, where these records there will not be any data from Colum F to I, that is why i suggested to use filter tool
@binuacs : I have data in 3 sections in same sheet.
I want to remove data from first section of data only. Because that portion only have yellow highlighted data.
Also, first section can also have any null values also from column F to column I. But, I would need to filter the data which has all the values blank.
Basically, data can be filtered on either of below:
1. Yellow highlighted data
2. Where all the values are null from column F to column I