I have a Calc sheet with a bunch of email addresses and other information. I want to filter out the duplicates. Should be really easy, but I’m getting pretty frustrated.
All of the answers I find on removing dupes are either outdated or using cryptic language that assumes that I know what the heck they’re talking about.
Please explain it to me like you’d explain it to your grandfather.
Here’s what appears to be the answer, though some of the path names seem to have changed:
Menu Data → Filter → Standard Filter… check Options No duplications and Copy results to: … enter a suitable location’s top left cell, for example on a new sheet created beforehand.
I’ve managed to get the box that asks me about filter criteria and offers the “Options” check-box, but where I run into problems is “enter a suitable location’s top left cell…” What the heck does that mean?
Okay, I know what it means, “Tell it where to write the information,” but I don’t know how it needs to be written.
Can someone please tell me how to get rid of the duplicates in my file?