Delete rows

[ana_scelza]

Hi everyone, hope all is well. 

I'm trying to delete some rows that would cause a 'duplicat' issue for my report. Typically, I would filter by color and highlight and delete all rows that contain the word "Results" in excel. 

How can I accomplish this same result? ie. I would get rid of rows containing the word "Result" 

[mceleavey · Accepted solution]

Hi @ana_scelza ,

use a filter tool and configure as follows:

The "T" output, or True output will contain the records you want.

Hope this helps,

M.

[echuong1 · Accepted solution]

You can either use a Filter tool or a Unique tool.

With a filter, you can specify to filter out rows that contain the word "result." Any values that do not contain this word would come out of the T output. Results containing "result" would come out of the F output.

Alternatively, if you're just looking to de-duplicate records, you can use a Unique tool. Simply check off any value that would be a unique ID for a line to keep.

See attached for examples of both.

[ana_scelza]

Thank you!

[echuong1]

No problem! Let me know if you have additional questions.

If this resolves your question, please mark this thread as Solved so others can find answers more easily. Thanks!

[ana_scelza]

It totally worked, thank you so much!

Now I need to apply it to every column that contains "Result"

[ana_scelza]

This really helped me a lot.