More than 1300 formula examples

Latest updated articles

Tue October 15, 2024

How to create date ranges in Excel

Tue October 15, 2024

How to compare two data sets

Tue October 15, 2024

Count cells containing text from list

Tue October 15, 2024

How to use the GROUPBY function

Tue October 15, 2024

Merge cell ranges into one list

Mon October 14, 2024

Build a maze programmatically in Excel

Mon October 14, 2024

Count cells based on color

Mon October 14, 2024

Filter unique distinct records

Fri October 11, 2024

How to use the MODE.SNGL function

Fri October 11, 2024

Most frequent value between two dates

Fri October 11, 2024

How to use the SORTBY function

Fri October 11, 2024

How to use the TEXTSPLIT function

Fri October 11, 2024

Team Generator

Fri October 11, 2024

Advanced Excel Chart Techniques

Fri October 11, 2024

How to use the PERMUTATIONA function

Thu October 10, 2024

Compare two columns in different worksheets

Thu October 10, 2024

How to use the SORT function

Thu October 10, 2024

Fuzzy VLOOKUP

Wed October 09, 2024

Extract a list of duplicates from a column

Wed October 09, 2024

How to perform a two-dimensional lookup

Wed October 09, 2024

How to create an interactive Excel chart

Wed October 09, 2024

Sort a column alphabetically

Wed October 09, 2024

Split expenses calculator

Wed October 09, 2024

How to solve simultaneous linear equations in Excel

Tue October 08, 2024

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

Tue October 08, 2024

Copy data from workbooks in folder and subfolders

Tue October 08, 2024

Excel calendar

Tue October 08, 2024

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

Tue October 08, 2024

How to use the FILTER function

Mon October 07, 2024

How to use the RANDBETWEEN function

Mon October 07, 2024

How to use the IF function

Mon October 07, 2024

Excel charts tips and tricks

Mon October 07, 2024

Lookup with any number of criteria

Mon October 07, 2024

Advanced Techniques for Conditional Formatting

Fri October 04, 2024

How to use the RANK.EQ function

Fri October 04, 2024

How to generate a round-robin tournament

Fri October 04, 2024

How to use the ENCODEURL function

Thu October 03, 2024

How to extract numbers from a cell value

Thu October 03, 2024

How to use VLOOKUP/XLOOKUP with multiple conditions

Wed October 02, 2024

Get date ranges from a schedule

Wed October 02, 2024

Find and return the highest number and corresponding date based on a condition

Wed October 02, 2024

How to use Pivot Tables – Excel’s most powerful feature and also least known

Wed October 02, 2024

How to highlight duplicate values

Wed October 02, 2024

Compare tables: Filter records occurring only in one table

Wed October 02, 2024

Remove common records between two data sets

Tue October 01, 2024

How to use the INT function

Tue October 01, 2024

Working with date ranges

Tue October 01, 2024

How to use the HYPERLINK function

Tue October 01, 2024

INDEX MATCH – multiple results

Tue October 01, 2024

How to use the SUMPRODUCT function

Tue October 01, 2024

Search for a file in folder and subfolders – UDF

Tue October 01, 2024

Rearrange values using formulas

Mon September 30, 2024

Extract unique distinct values in an Excel Table filtered list

Mon September 30, 2024

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

Mon September 30, 2024

VLOOKUP – Return multiple unique distinct values

Mon September 30, 2024

How to use the TEXTJOIN function

Mon September 30, 2024

Count unique distinct values

Mon September 30, 2024

How to use the AVERAGE function

Fri September 27, 2024

Count unique distinct records

Thu September 26, 2024

Create a Print button – macro

Thu September 26, 2024

Create new worksheets programmatically based on values in a cell range [VBA]

Excel categories


Home page
Excel Functions
Excel Formulas
Excel Tables
Advanced Filter
Data Validation
Drop Down List
Named Ranges
Excel Solver
Charts
Conditonal Formatting
Pivot Tables
VBA
Macros
UDFs
Archive