How to extract the unique list of items or we can extract the specific item from different excel's worksheets?

Advanced filter

 We use Advanced filter to extract the unique list of items or we can extract the specific item from different excel's worksheets. We can say that Advanced filter is an advanced version of Auto filter.

Example:

In a range, we have duplicate products and we want to filter only unique list.

 

 

Follow below steps:

• Select the data range
• Go to Data tab > Click on Advanced
• Advanced dialog box will open
• Click on copy to another location
• Select the destination

 

 

• Click on OK

 

 

 

Dears , 

 

the best way to do this , use the "advanced filter" option .

 

 

 

thanks for the invitation

Usual professor Ghada

Technical questions beautiful, wonderful answers, professors

Use an Advanced Filter in Excel to create a list of unique items, or to extract specific items to a different worksheet. You can also use complex criteria with an Advanced Filter, so it is useful when a simple AutoFilter can't do what you need

Advance filter is the best for selecting items of same group/ date etc in Excel sheet  & to extract the items from other worksheet is best to make Hyperlink.

 

Best Option is Advanced filter, and the Best Explanation by Mrs. Ghada Eweda.

 

This is the quality of MS Excel, that you can use many formula to make customize sheets,

Following are the methods you can use:

• Filters
• Vlookup or Hlookup
• IF then else commands
• pivot table
• Conditions e.g. less than greater than or equal to etc etc

 

thanks for the useful invitation 

Extract meaning to move or to change, it means your command might be copy and paste, convert from text to number,  text to column or use function command Ex. concatenate  and etc. it's up to you how you do it.

Fully agree with your answer Ghada. Very insightful. Thanks for the invitation, by the way.

Thanks for the invite I agree with the answers relevant experts