Find the Nth Matching Value

Use LET and MID to Uncover Your Values

Get the Last Row Number Even When the Data Contains Blank Rows

Thank You - 1,000 Subscribers

Using Multiple Criteria in Excel’s MATCH Function

Set Alternating Row Colors in Excel

Use Excel to Create Multiple Random Samples

Use Excel’s FILTER and LET Functions to Show Rows with Blank Cells

Two Excel Equations to Extract Decimals

Randomly Assign Values to Groups Using Excel 365 or 2021

Add More Control When Using Wildcards With Excel's FILTER Function

Assigning Cutoffs In Excel Based On Numeric Values

Access Your Lambda Equations From Any New Excel Workbook

5 Annoying PivotTable Behaviors…And How To Fix Them

How to Use XLOOKUP…In Less Than 5 Minutes

Having Fun with Conditional Formatting | Mimicking Merged Cells…but Better

Round Values to the Nearest 5, 10, 25, or…Anything in Excel

Filling Blank Cells with Above Values in Excel

Summarize Your Data By Day Using Excel’s PivotTables

Randomize Your Data in Excel

How to Correctly Sum Values in a Filtered Excel Dataset

Deleting All Blank Rows In An Excel Dataset

Filter Every Nth Row in Excel

Find Row Numbers of Blank Cells in Excel

Using Multiple Criteria within the FILTER Function

Our First 100 Subscribers…Thank You

How to Use Excel’s FILTER Function…In Three Minutes

Work Faster in Excel with These 10 Essential Keyboard Shortcuts

How to Flip Signs for a Range of Numbers in Excel

Welcome to ExcelSmith