http://www.onlinepclearning.com
In this tutorial we will be adding our advanced filters. The first advance filter will be extracting the data for our calendar. The second advanced filter we will use for stopping duplicates from occurring. This video also explains the reason why these two filters are necessary and the formulas used to create the criteria block.
Tutorial Link
http://www.onlinepclearning.com/excel...