Formulas & functions
How a function works, with worked examples you can paste.
- How to Filter for Duplicates in ExcelTo show only duplicate values in Excel, select the cells you want to check, choose Home > Conditional Formatting > Highlight Cells…
- How to Filter Greater Than in Excel: Step-by-Step GuideTo show only values above a threshold in Excel, open the column’s filter menu and choose Number Filters > Greater Than, then…
- How to Filter Excel Cells: A Practical Step-by-Step GuideTo filter Excel cells, select a cell in your data, choose Data > Filter, then use the arrow in a column heading…
- How to Filter Excel to Hide Duplicate Values in a ListTo filter a list so repeated full rows are hidden, select the data, go to Data > Sort & Filter > Advanced,…
- Filter Dates in Excel Oldest to Newest: A Step-by-Step GuideTo put dates in chronological order in Excel for Microsoft 365 on Windows, select a cell in the date column, then choose…
- How to Filter Dates in Excel: A Step-by-Step GuideTo filter dates in Excel, select a cell in your data, choose Data > Filter, open the dropdown in the date column,…
- How to Filter Dates in ExcelTo filter dates in Excel for Microsoft 365 on Windows, select a cell in your data, choose Data > Filter, open the…
- Filter Date Order in Excel: Sort Dates Oldest to NewestTo put Excel dates in order, select a cell in your data and choose Data > Sort Oldest to Newest or Data…
- How to Filter Dates by Quarter in ExcelTo filter dates by quarter in Excel, turn on the filter for your date column and choose the relevant quarter from its…
- How to Filter by Year in Excel: A Clear, Practical GuideTo filter a date column to one calendar year in Excel, select your data, choose Data > Filter, open the date column’s…
- How to Filter Crossed-Out Text in ExcelExcel cannot filter rows directly by strikethrough formatting. The practical method is to use a short VBA macro to mark cells with…
- How to Filter by Number in Excel: A Step-by-Step GuideTo filter by number in Excel, select a cell in your data, choose Data > Filter, open the arrow in the numeric…
- How to Filter by Strikethrough in Excel (Step by Step)Excel does not have a built-in filter that detects strikethrough formatting. The most reliable workaround is to create a helper column that…
- Filter by Month in Excel: Step-by-StepTo filter Excel dates to one particular month and year, open the date column’s filter menu and choose Date Filters > Between,…
- How to Filter by Name in Excel: A Step-by-Step GuideTo filter by name in Excel, select a cell in your data, choose Data > Filter, then use the dropdown in the…
- How to Filter by Column in ExcelTo filter by a column in Excel, select a cell in your data, choose Data > Filter, then open the arrow in…
- How to Filter Purchases by Date in Excel, Step by StepTo filter purchases by date in Excel, select your purchase list, choose Data > Filter, open the arrow in the purchase-date column,…
- How to Filter and Sort Data in Excel: A Practical GuideTo filter and sort data in Excel, select a cell in your list, choose Data > Filter to show dropdowns, and use…
- How to Filter Blank Cells in Excel and Find Empty RowsTo filter blank cells in Excel, turn on filtering for your data, open the dropdown in the column you want to check,…
- How to Filter an Excel Sheet by DateTo filter an Excel sheet by date in Microsoft Excel for Microsoft 365 on Windows, select a cell in your data, choose…
- How to Filter A-Z in Excel: Sort a List the Right WayTo put Excel entries in alphabetical order, select a cell in the column and choose Home > Sort & Filter > Sort…
- How to Filter a Column in Excel by Dates or Date RangeTo filter dates in Excel for Microsoft 365 on Windows, select a cell in your data, choose Data > Filter, open the…
- Extract Words in Excel Using Formulas: Step-by-StepTo return the first word from text in A2, use =IFERROR(TEXTBEFORE(TRIM(A2)," "),TRIM(A2)). For the last word, a particular word, or every word…
- How to Extract Text in Excel With Formulas and ExamplesTo extract text in Excel, use functions such as LEFT, RIGHT, MID, and FIND to return the characters you need from a…
- Extract Text From a Cell in Excel With Simple FormulasTo extract part of a cell’s text in Excel, use a formula that matches what you need: for example, with a hyphen-separated…
- How to Extract One Word From a Cell in Excel With FormulasTo extract a particular word from text in Excel for Microsoft 365, put the text in A2 and the word number in…
- Extract Initials from Names in Excel with FormulasTo extract the first letter of every word in a name, enter a formula in the next column and fill it down.…
- Extract the First Word from a Cell in Excel with a FormulaTo extract the first word from a cell in Excel, enter =LEFT(TRIM(A2),FIND(" ",TRIM(A2)&" ")-1) in an empty cell, replacing A2 with the…
- Extract the First Word in Excel With a FormulaTo extract the first word from text in Excel, put the source text in A2 and enter =LEFT(TRIM(A2),FIND(" ",TRIM(A2)&" ")-1) in another…
- Extract Day from Date in Excel: Formula and StepsTo extract the day of the month from an Excel date, put the date in A2 and enter =DAY(A2) in another cell.…