Formulas & functions
How a function works, with worked examples you can paste.
- How to Match Names Across Two Excel Spreadsheets QuicklyTo find names from one Excel spreadsheet in another, put the names to check in column A and use COUNTIF to test…
- Excel LEFT of a Character: Formula and ExamplesTo return everything to the left of a character in Excel, combine LEFT with FIND: with the text in A2 and a…
- Find Matching Names in Two Excel Columns With FormulasTo find names in column A that also appear in column B, enter =IF(COUNTIF($B$2:$B$100,A2)>0,"Match","Not found") beside the first name and fill the…
- Find Duplicate Names in Excel: Formulas and ToolsTo find duplicate names in Excel, select the name cells and choose Home > Conditional Formatting > Highlight Cells Rules > Duplicate…
- Excel Filter Shortcut: Alt Keys and Faster OptionsIn Excel for Microsoft 365 on Windows, press Alt, then A, then T to apply or remove AutoFilter; press the keys one…
- Filter Out Strikethrough Text in Excel: A Practical GuideExcel for Microsoft 365 does not have a built-in filter condition for strikethrough formatting. To filter those rows, add a helper column…
- Filter Search Shortcut in Excel: Find Values FastIn Excel for Microsoft 365 on Windows, press Ctrl+Shift+L to turn column filters on or off. To search a column’s filter list,…
- Filter Duplicates in Excel: Remove or Show Unique RowsTo remove duplicate rows in Excel for Microsoft 365 on Windows, select your data, then choose Data > Remove Duplicates, select the…
- Filter Duplicates in Excel: Keep One or Remove All?To remove duplicate entries in Excel for Microsoft 365 on Windows, select your data and choose Data > Remove Duplicates; Excel keeps…
- Filter Excel Using Multiple Criteria: Steps and TipsTo filter Excel using multiple criteria, select a cell in your data and choose Data > Filter, then apply a filter to…
- Filter Excel Using a PivotTable: Practical Steps and TipsTo filter Excel data with a PivotTable, click inside the PivotTable, open the PivotTable Fields pane, and drag the field you want…
- Filter Excel Table Without a Header: What WorksExcel filtering needs a header row: if you apply Filter to a headerless range, Excel treats its first row as the headers,…
- Filter Excel Table by Multiple Criteria: Methods That WorkTo filter an Excel table by multiple criteria, open a column’s filter arrow and set its rule; rules on different columns are…
- Filter an Excel Table by Column: Steps, Tips & FixesTo filter an Excel table by column in Microsoft 365 for Windows, select the table, open the drop-down arrow in the column’s…
- Filter Excel Table by Criteria: A Practical Excel GuideTo filter an Excel table by criteria, open the drop-down arrow in the column header, choose a value or a filter rule,…
- Filter Excel Rows by Cells That Contain Specific TextTo filter Excel rows by text inside a cell, turn on AutoFilter, open the filter arrow in the relevant column, then choose…
- How to Filter an Excel Sheet by Text: Steps and TipsTo filter an Excel sheet by text in Microsoft 365 for Windows, select a cell in your data and choose Data >…
- Filter Excel Remove Duplicates in a ListExcel’s Filter command hides rows; it does not remove duplicate entries. To delete duplicates, select the full data range and choose Data…
- Filter Excel Data by Text: Steps and Useful OptionsTo filter Excel data by text in Microsoft 365 for Windows, select a cell in your data, choose Data > Filter, open…
- Excel FILTER Function With Multiple CriteriaYes. In Microsoft Excel for Microsoft 365, use the FILTER function with multiplication between conditions for AND logic, or addition for OR…
- How to Filter Excel by Date: Ranges, Months, and YearsTo filter Excel by date, select a cell in your data, choose Data > Filter, open the arrow in the date column’s…
- Filter Duplicate Data in Excel: Find or Remove RowsTo filter duplicate records in Excel, add a helper column with a COUNTIF formula, then filter that column for TRUE; to delete…
- How to Filter Dates in Excel by Day, Month, or RangeTo filter dates in Excel, select a cell in your data, choose Data > Filter, open the arrow in the date column,…
- Filter Cells With Specific Text in Excel: A Quick GuideTo filter cells by text in Excel for Microsoft 365 on Windows, select your data, choose Data > Filter, open the arrow…
- Filter Data Between Two Dates in Excel: A Practical GuideTo filter data between two dates in Excel for Microsoft 365 on Windows, select a cell in your data, choose Data >…
- Filter by Two Criteria in Excel: A Practical GuideTo filter by two criteria in Excel, turn on filters with Data > Filter, then set a condition in each relevant column;…
- Filter by Date Range in Excel: Steps and TipsTo filter a date range in Excel for Microsoft 365 on Windows, open the filter arrow in your date column, choose Date…
- Extract PAN from GSTIN in Excel: Formula and ChecksYes. If a GSTIN is in cell A2, extract its embedded 10-character PAN with =MID(A2,3,10). The formula takes 10 characters beginning at…
- Extract Dates From Text in Excel: Formulas and FixesTo extract a date from text in Excel for Microsoft 365, isolate the date text and convert it with DATEVALUE. For example,…
- Excel XLOOKUP With Multiple Criteria: Formulas & TipsTo use XLOOKUP with multiple criteria in Excel, multiply the criteria tests to require every condition to be true, then search for…