How can I paste a unique values list?

I have a very big list contains a lot of repeated values and I want to get a
copy of the same list BUT only with unique values. For Example the column
Reg.No. includes the following Numbers:
1154
1168
1166
1154
908455
907558
1166
908455
1154
1166

List might have thousans of records. I want to get a copy of this list
without repeating any of the numbers included. { Uniqe value list }.

Thanks and regards.

JAK

You can add a header, select the range, do data>filter>advanced filter,
select copy to another location and unique records only

--
Regards,

Peo Sjoblom

(No private emails please)


"jak roodi" <jak [email protected]> wrote in message
news:[email protected]...
>I have a very big list contains a lot of repeated values and I want to get
>a
> copy of the same list BUT only with unique values. For Example the column
> Reg.No. includes the following Numbers:
> 1154
> 1168
> 1166
> 1154
> 908455
> 907558
> 1166
> 908455
> 1154
> 1166
>
> List might have thousans of records. I want to get a copy of this list
> without repeating any of the numbers included. { Uniqe value list }.
>
> Thanks and regards.
>
> JAK

Hi,

You can do it by using the filter options in data menu. Just check this
steps out.

Go to data --> FILTER --> advanced filter --> Select copy to another
location --> select the list range -> select the new location where data
should be copied --> Check Unique records and click on OK.

That should work.

C Ya.

--
Message posted via http://www.officekb.com

Jak

If you want the unique list to be in another sheet be sure
to activate that sheet prior to using Peo's and Joham's
suggestion.

--
Best Regards
Leo Heuser

Followup to newsgroup only please.

"jak roodi" <jak [email protected]> skrev i en meddelelse
news:[email protected]...
>I have a very big list contains a lot of repeated values and I want to get
>a
> copy of the same list BUT only with unique values. For Example the column
> Reg.No. includes the following Numbers:
> 1154
> 1168
> 1166
> 1154
> 908455
> 907558
> 1166
> 908455
> 1154
> 1166
>
> List might have thousans of records. I want to get a copy of this list
> without repeating any of the numbers included. { Uniqe value list }.
>
> Thanks and regards.
>
> JAK