Copying only the unique values from a set of cells in OpenOffice.org Calc spreadsheets

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.

Click OK.

You'll get only the unique values from that cell range, pasted starting at the cell you specified.

---

---

Comments

[rodrigo]

nice tips.

-----

Buen dato.

[Umesh]

A very useful tip and with good explanation.
--
Umesh

[Joshua Issac]

Thanks a lot!

[gudata]

Thank you! very good tutorial.

[Petteri]

Thanks, a very good tip for OpenOffice! :)

Greetings from Finland!

[Ben]

Awesome!