This video is perfect illustration over usage of advance filter in Ms Excel. This video shows how to use advance filter from beginner level to advance level with several examples.
