In this video I explained basic and bit advance filter function in Excel and for your information advance function works in MS Office 2021 or above version Office 365. If you don't have any of these you can use Google Spreadsheet to do it.
Sample File URL:- https://docs.google.com/spreadsheets/...