Advance filter available in "Data" ribbon is used to filter your data with some complex criteria. To use advance filter option you have to create a criteria for your filter. The criteria table should have the same set of headings with respect to your data list. Scenario - We would like to filter Quarter 1 sales from state Karnataka in the below given data set.
Step 1: Have your data set ready
Step 2: Create your criteria
Step 3: Go to "Data" Ribbon and click "Advance Filter" option. This will pop out the following dialog box. You will get an option called Action. Select "Copy to another location" radio button then select the data set range from which you want to filter your criteria and then select the criteria which you would like to filter. Once this is done locate the place in the same sheet or any other sheet where you want to have the output. Hit OK and there you go you will get the desired result.
For more information on how to do this, please get in touch with me at Samrat.Biswas@ hotmail.com or Samrat.biswaas@gmail.com
Friends, Now Excel in MS Excel is available in Facebook as well. You can quickly raise your MS Excel related queries in its platform. I will try to resolve them.
Visit Other MS Excel Tips and Tricks
Usage of Document Inspector
Samrat Biswas, Six Sigma (Green Belt), MOS Excel Expert 2013, ITIL 2011 Foundation
Advanced MS Office (Excel, Word, PowerPoint, One Note, Outlook), and MS Visio
---------------------------------------------------------------------------------------------------------
Be a part of regular Weekend Knowledge Sharing Sessions
Reach me @ +91 8095039316
https://www.facebook.com/Samrat.Biswas
Step 1: Have your data set ready
Step 2: Create your criteria
Step 3: Go to "Data" Ribbon and click "Advance Filter" option. This will pop out the following dialog box. You will get an option called Action. Select "Copy to another location" radio button then select the data set range from which you want to filter your criteria and then select the criteria which you would like to filter. Once this is done locate the place in the same sheet or any other sheet where you want to have the output. Hit OK and there you go you will get the desired result.
Friends, Now Excel in MS Excel is available in Facebook as well. You can quickly raise your MS Excel related queries in its platform. I will try to resolve them.
Visit Other MS Excel Tips and Tricks
Usage of Document Inspector
Samrat Biswas, Six Sigma (Green Belt), MOS Excel Expert 2013, ITIL 2011 Foundation
Advanced MS Office (Excel, Word, PowerPoint, One Note, Outlook), and MS Visio
---------------------------------------------------------------------------------------------------------
Be a part of regular Weekend Knowledge Sharing Sessions
Reach me @ +91 8095039316
https://www.facebook.com/Samrat.Biswas
No comments:
Post a Comment