Logo 
Search:

MS Office Answers

 Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds
  Question Asked By: Adalicia Martin   on Aug 28 In MS Office Category.

How to extract unique entries from a particular column in a range


  
Question Answered By: Eshe Chalthoum    on Aug 28

You can use Advanced Filter option of Excel.

I think you can use following steps.

Go to Data
Select Adavanced Filter
Select Copy to another Location
In List Range Select Column A
in Copy to Select G1
Check Unique Record
Press OK

Share: 

 

This Question has 1 more answer(s). View Complete Question Thread

 


Tagged: