How To remove excel rows and Columns

Dear Experts,

I want to remove excel columns and rows with condition
if today date and excel date is same
then i should remove today date from end of the month.

just I tried ,
remove data column activity
remove data row activity
remove duplicate rows.


for your references
could anyone help me on this.

Thanks in Advance
Abu

1 Like

Hi @Abubakkar

Use Filter data table activity

image

cool,
Regards,
Gulshiyaa

2 Likes

HI @Abubakkar,
To remove duplicate that you can use the below activity.

Remove the Column and Rows contiguous

Thank you
Balamurugan.S

1 Like

Hi @Abubakkar

Yes @gulshiyaa suggestion is also a good one. But you are not able to achieve it. you can try mine.

Regards
Balamurugan.S

1 Like

Thanks for the response @gulshiyaa

but, column date is just number format

Thanks @balupad14

i getting this error message

what should i mention in range ? i want to delete today’s date from end of the month till

2 Likes

Hi ,
Like A1:R10(The total used range)… The column is 4. So it will remove 3 rows…

Regards
Balamurugan.S

2 Likes

sorry, I am not able to get your point. Can you explain me again plz
condition is : if today date and excel column is same then i should delete today’s date column to end of the month date till.