Update the excel column value according to the filter

Hi,
I have an excel there i want to filter column response according to the the responses i have update the next column status.

I have tried
Dr=dt.select("[response]=‘Remove’") but its not working…
Can anyone please help me on this.

2 Likes

Hi @Sarah2
I didn’t get well the question can you elaborate more ?

cheers :smiley:

Happy learning :smiley:

2 Likes

@Sarah2

If you want to update excel only you can update it directly to excel. like this.
See image below for your reference.

image

cheers :smiley:

Happy learning :smiley:

3 Likes

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.