Unique list

Hello Seema,

With regards to the question, you can use advanced filter, copy to another location, and tick the unique values only option. You can find the advanced filter option in the data ribbon.

I hope this resolves your question. If it has, please mark this question as resolved.

If you require further assistance, please reply to this post. Or perhaps you have another Microsoft Office question?

Have a great day.
Regards,

Mark
Microsoft Office Specialist Trainer