How to Separates Unique Records in MS Excel ?

Some time we have Long List, and we have some common Words. If we want to separates some common words in New column we have to use Advanced Filter.
Step-1 Write the names in sheet
Step-2 Click Data Menu and Click on Filter then Click on Advance Filter.
Step-3 Select "Copy to Another Location"
Step-4 Give the List range by Selecting A2 to A10
Step-5 Click Copy to and give range B2
Step-6 Check Unique records only. Click OK and see the Result
You will see Unique List.

Comments

Popular posts from this blog

How to get Day name In Excel ?