Look at advanced filter which allows you to copy unique values to a new
location.

DataFilterAdvanced Filter.

--
HTH

Bob Phillips

"Remote Desktop Connection hotkey"
ft.com wrote in message
...
I have column B with 20 values in it. Some of the values repeat more than
one
time. For example word fox appears 2 times, word wolf appears 4 times
e.t.c

Is there any way to group non-unique values? I mean like perform select
with
grouping ? For example I have range of values B1:B20 and i want to put
resulting range to C1:C20, but i only want to have unique values in
resulting
range.
If excel would support SQL in order to get resulting range i want, i would
write: "SELECT DISTINCT column B FROM workbook1"