Get Digital Help

More than 1300 formula examples

Latest updated articles

Thu February 20, 2025

Populate drop down list with unique distinct values sorted from A to Z

Thu February 20, 2025

Comparing Excel Sorting Techniques: Formulas, Tools, and VBA

Wed February 19, 2025

Auto resize columns as you type

Wed February 19, 2025

Lookup a date in date ranges and get the corresponding value

Tue February 18, 2025

Extract records between two dates

Tue February 18, 2025

How to animate an Excel chart

Tue February 18, 2025

Yet another Excel Calendar

Mon February 17, 2025

Run a macro every time a workbook opens or closes

Mon February 17, 2025

Filter unique distinct records case sensitive

Mon February 17, 2025

How to use the Scroll Bar

Fri February 14, 2025

How to use DIALOG BOXES

Fri February 14, 2025

How to track sector performance in the stock market – Excel template

Thu February 13, 2025

Filter duplicate values based on criteria

Thu February 13, 2025

Excel template: Getting Things Done [VBA]

Wed February 12, 2025

How to use the Subtotal tool

Wed February 12, 2025

How to use the FREQUENCY function

Wed February 05, 2025

How to improve your Excel Chart

Tue February 04, 2025

Excel chart components

Tue February 04, 2025

Cleaning Up Excel Worksheets: Eliminating Blank Cells, Rows, and Errors

Mon February 03, 2025

How to use the OFFSET function

Mon February 03, 2025

Filter unique distinct records

Mon February 03, 2025

Extract unique distinct values from a multi-column cell range

Mon February 03, 2025

Sort a column alphabetically

Mon February 03, 2025

5 easy ways to extract Unique Distinct Values

Mon February 03, 2025

Working with unique values

Mon February 03, 2025

Extract a unique distinct list sorted from A to Z

Mon February 03, 2025

Partial match for multiple strings – AND logic

Mon February 03, 2025

Advanced Date Highlighting Techniques in Excel

Mon February 03, 2025

How to highlight duplicate values

Mon February 03, 2025

Count unique distinct values

Mon February 03, 2025

Find missing numbers

Mon February 03, 2025

How to create date ranges in Excel

Mon February 03, 2025

Extract a unique distinct list from multiple non adjacent cell ranges

Mon February 03, 2025

Extract a list of duplicates from a column

Mon February 03, 2025

How to perform a two-dimensional lookup

Mon February 03, 2025

Merge cell ranges into one list

Mon February 03, 2025

Search for a text string in a data set and return multiple records

Mon February 03, 2025

Extract duplicates from a multi-column cell range

Mon February 03, 2025

How to list unique distinct values sorted by frequency

Sun February 02, 2025

Extract all rows from a range that meet criteria in one column

Sun February 02, 2025

5 easy ways to VLOOKUP and return multiple values

Sun February 02, 2025

Find the most recent date that meets a particular condition

Sun February 02, 2025

Identify numbers in sum using Excel solver

Sun February 02, 2025

How to return a value if lookup value is in a range

Sun February 02, 2025

Create number series

Sun February 02, 2025

Match two criteria and return multiple records

Sun February 02, 2025

Split data across multiple sheets – VBA

Sun February 02, 2025

Automate net asset value (NAV) calculation on your stock portfolio

Sun February 02, 2025

Plot date ranges in a calendar

Sun February 02, 2025

Extract dates from overlapping date ranges

Sun February 02, 2025

Create dependent drop down lists containing unique distinct values

Sun February 02, 2025

Team Generator

Sun February 02, 2025

Save invoice data – VBA

Sun February 02, 2025

Create a Print button – macro

Sun February 02, 2025

Lookup and return multiple values concatenated into one cell

Sun February 02, 2025

Compare tables: Filter records occurring only in one table

Sun February 02, 2025

Count unique distinct records

Sun February 02, 2025

Monthly calendar template

Sun February 02, 2025

A Comprehensive Guide to Splitting Text in Excel

Sat February 01, 2025

Fuzzy VLOOKUP

Sat February 01, 2025

How to highlight differences and common values in lists

Excel categories

Conditonal Formatting

Pivot Tables

VBA

Macros

UDFs