How to Display Rows that have a Specific Value in a Column

[megnelaz]

Another issue I had was ensuring the lists that contained specific values from a column did not repeat values. I found the code circled in green in this article helpful:

[Solved] How can I delete one if there are two identical names in the list?

I made a list and I get unwanted copying. So if there are two identical names in the list I want to delete one. What is the best way to do this?