Removing rows with specific condition on excel output

[ricardoestradah]

Hi everyone,

Im trying to remove the rows where a condition is met. This runs every day and just need to keep the ones without the Y and keep the others. For instance:

Input file sheet1 (same as the output file for current day):

Name	Iphone
Mike	N
Richard	Y
Peter
John	Y

the same sheet should be overrided and the output must be (sheet1):

Name	Iphone
Mike	N
Peter

Appreciate all the help!

[DataNath · Accepted solution]

Hey @ricardoestradah, to remove the 'Y' entries, you can just use a Filter tool like so:

To then Output your result, ensuring that you overwrite the existing file, just use the same configuration as shown here (obviously selecting the input file as the output to then overwrite):

[ricardoestradah]

Thanks that worked !

[ricardoestradah]

Thanks, that worked!