Excel Advanced Filter is one of the most underrated and under-utilized features that I have come across. If you work with Excel, I am sure you have used (or at least heard about the regular excel filter). It quickly filters a data set based on selection,

Excel tutorial: How to use search and replace functions: BENKIRANE Fatima Ezzahra : 477 : 3 : Excel Tutorial : How to count and add cells by color: BENKIRANE Fatima Ezzahra : 397 : 4 : How to recover/restore an unsaved Excel file: BENKIRANE Fatima Ezzahra

Or Criteria. To display the sales in the USA in Qtr 4 or in the UK in Qtr 1, execute the following steps.. 6. Enter the criteria shown below on the worksheet. 7. On the Data tab, in the Sort & Filter group, click Advanced, and adjust the Criteria rang