suppose your data is like this from A1 to A9(note colufmn heading -this is necessary)
choose radio button at the top "copy to another location"
against list range click the icon at the right end of the small window and highlight A1 to A9
leave blank criteria range
against "copy to"-click the icon at the right end of the window and select some empty cell e.g. D1
choose radio button "unique records only" at the bottomleft
you will get D1 to D4
in E2 copy paste this formla (repeat E2)
copy E2 down.
you will get
will this do?
you can modify this help to suit you