So there you are. You've got a whole bunch of people signed up for various events you're planning. Or they've ordered a bunch of your products. Some have signed up for more than one event; some have ordered more than one product. You want to just get a list of the customers who've signed up. If a customer has signed up for three events, you just want her name to appear once. You just want the unique values.
One thing you can do is use the Standard Filter.
Select the column of data, either with the heading or without.
Choose Data > Filter > Standard Filter.
Select None as the Field Name then click More.
- If you didn't select a column heading like Customer, deselect Range Contains Column Labels.
- Select No Duplication
- Select Copy Results To, click in the empty field, then either type the sheet and cell where you want it copied, or click in the cell in your spreadsheet where you want it copied.
You'll get only the unique values from that cell range, pasted starting at the cell you specified.