selecting unique items
You need to have a header above your column for the following method
to work, so if you don't have one then insert a new row 1 and enter
"Countries" in A1.
Highlight all your data (plus heading) in column 1, then click on Data
| Filter | Advanced Filter - in the pop-up you should select Unique
Records Only as well as Copy to Another Location and in the Copy To
box put C1 (or some other reference if you have data in column C
already).
Then click OK and you will have your unique list in column C.
Hope this helps.
Pete
On Feb 7, 11:02*am, Mortir wrote:
i have the following case:
in one column I have some items that repeat themselves, now id like to
extract in another column only uniqu items. example
Column A
austria
belgium
latvia
latvia
greece
greece
what id like to get is
austria
belgium
latvia
greece
No repetitions. Is there a way i can do this?
|