Formulas & functions
How a function works, with worked examples you can paste.
- Excel Filter in Table Format: How to Set Up and Use ItTo filter data in an Excel table, click a cell in the table and use the drop-down arrow beside a column heading…
- Excel FILTER Function: Filter Rows by Partial TextTo return rows where a column contains part of a word or phrase, combine Excel’s FILTER function with SEARCH. For example, with…
- Excel FILTER Function With Dates: Examples and TipsTo filter rows by date in Excel, use the FILTER function with a date comparison as its include condition. For example, with…
- Excel FILTER Function With Table ReferencesIn Excel for Microsoft 365, use the FILTER function with a table name and a structured column reference, such as =FILTER(tblOrders,tblOrders[Region]="West","No matching…
- Excel FILTER and UNIQUE: Remove Duplicate Rows EasilyExcel’s FILTER function does not remove duplicates by itself; combine it with UNIQUE to return distinct rows that meet a condition. With…
- Excel FILTER Function: Return Results Without DuplicatesExcel’s FILTER function does not remove duplicates by itself. To return matching results without repeats, wrap FILTER inside UNIQUE; for example, use…
- Excel FILTER Function for Duplicates: Find RepeatsWith IDs in A2:A100 and full records in A2:D100, enter =FILTER(A2:D100,COUNTIF(A2:A100,A2:A100)>1,"No duplicates") to return every row whose ID appears more than once.…
- Excel FILTER Function for Text: Examples and TipsWith records in A2:C6 and the text to match in B2:B6, use =FILTER(A2:C6, B2:B6="North", "No matching rows") to return every row whose…
- Excel FILTER Function: Find Cells That Contain TextYes. In Excel for Microsoft 365, FILTER can return rows where a cell contains particular text by combining it with SEARCH. With…
- Excel FILTER Function: Find Rows Using Partial TextYes. In Excel for Microsoft 365, FILTER can return rows whose text contains a word or phrase by combining it with SEARCH.…
- Excel FILTER Formula for No DuplicatesTo return a changing list with duplicates removed, combine Excel’s FILTER and UNIQUE functions. With values in A2:A100 and blanks to exclude,…
- Excel FILTER Formula: Remove DuplicatesTo return filtered results without duplicates in Excel, combine FILTER with UNIQUE: FILTER selects the rows you want, and UNIQUE removes repeated…
- Excel FILTER Formula: Find Partial Text MatchesTo return rows where a cell contains part of a word or phrase, combine Excel’s FILTER and SEARCH functions: =FILTER(A2:C6,ISNUMBER(SEARCH("west",B2:B6)),"No matches"). In…
- Excel FILTER Formula to Find Cells Containing TextTo return rows where a column contains particular text, combine Excel’s FILTER function with SEARCH: with records in A2:C100 and the text…
- Excel Filter for Duplicate Values: Find and Review ThemTo filter duplicate values in Excel for Microsoft 365 on Windows, add a helper column with =COUNTIF($A$2:$A$100,A2)>1, fill it down, and filter…
- Excel Filter for Specific Text: Steps and ExamplesTo filter Excel rows for specific text in Microsoft 365 on Windows, select a cell in your data, choose Data > Filter,…
- Excel Filter for Strikethrough Text: Practical OptionsExcel’s standard filter cannot filter directly by strikethrough formatting. In Microsoft 365 for Windows, the practical solution is to add a helper…
- Excel Filter: Exclude Specific Text from ResultsIn Excel for Microsoft 365 on Windows, open the filter arrow on the column you want to check, choose Text Filters >…
- Excel Filter: How to Exclude Text From Your ResultsTo exclude rows containing particular text in Excel for Microsoft 365 on Windows, open the column’s filter arrow, choose Text Filters >…
- Excel Filter Duplicates Without Deleting Data SafelyYes. In Excel for Microsoft 365 on Windows, add a helper column that identifies repeated values, then choose Data > Filter to…
- Excel FILTER Formula with Multiple Criteria ExplainedIn Excel for Microsoft 365, use FILTER with multiplication between conditions when every criterion must be true, and addition when any one…
- Excel Filter Duplicates: Keep the First RecordTo keep the first occurrence of each value in Excel, select the full data range and choose Data > Data Tools >…
- Excel Filter Duplicates Across Multiple ColumnsYes. In Excel for Microsoft 365 on Windows, add a helper column that counts how often each row’s values occur across the…
- Excel Filter: Hide Duplicate Values Without Deleting RowsYes. To show each distinct value once without deleting data, use Data > Advanced and select Unique records only, or enter Excel’s…
- Excel Filter Duplicates: Is Matching Case-Sensitive?No. In Excel for Microsoft 365 on Windows, the regular filter and built-in duplicate tools do not distinguish text by letter case:…
- Excel Filter Duplicates in a Column: A Practical GuideYes. In Microsoft Excel for Microsoft 365, add a helper column with =COUNTIF($A$2:$A$100,A2)>1, fill it down, then turn on Data > Filter…
- Excel Filter Dates Within a Range: Steps and FixesTo filter Excel dates within a range, select a cell in your data, choose Data > Filter, open the date column’s dropdown,…
- Excel Filter Does Not Contain Text: How to Exclude MatchesTo show rows whose cells do not include particular text, open the column’s filter menu and choose Text Filters > Does Not…
- Excel Filter Dates by Week: Quick MethodsTo filter dates for the current or a nearby week in Excel for Microsoft 365 on Windows, select a cell in your…
- Excel Filter Dates by Year: Quick Steps and FixesTo filter dates by year in Excel for Microsoft 365 on Windows, open the filter arrow in the date column and select…