View Single Post
  #4   Report Post  
Leo Heuser
 
Posts: n/a
Default

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 skrev i en meddelelse
...
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