More than 1300 formula examples

Latest updated articles

Wed November 20, 2024

How to do tiered calculations in one formula

Tue November 19, 2024

How to use the BIN2DEC function

Tue November 19, 2024

How to use the TODAY function

Tue November 19, 2024

How to use the TEXTAFTER function

Tue November 19, 2024

How to use the EOMONTH function

Wed November 13, 2024

Extract a list of duplicates from a column

Wed November 13, 2024

How to use the RANK.AVG function

Fri November 08, 2024

How to use the PROB function

Fri November 08, 2024

How to use the XMATCH function

Fri November 08, 2024

How to use the WRAPROWS function

Fri November 08, 2024

How to use the EDATE function

Wed November 06, 2024

How to use the CLEAN function

Wed November 06, 2024

How to use the ISTEXT function

Tue November 05, 2024

How to use the TYPE function

Tue November 05, 2024

How to use the REPT function

Mon November 04, 2024

How to use the NETWORKDAYS.INTL function

Mon November 04, 2024

How to use the MONTH function

Thu October 31, 2024

How to use the HSTACK function

Thu October 31, 2024

How to use the BIN2HEX function

Thu October 31, 2024

How to use the BITOR function

Tue October 29, 2024

How to use the BIN2OCT function

Tue October 29, 2024

How to use the BITXOR function

Tue October 29, 2024

Complex Calculations: A Guide to Excel’s IM Functions

Mon October 28, 2024

Engineering functions – D to IMC

Thu October 24, 2024

How to use the VSTACK function

Thu October 24, 2024

How to use the TOCOL function

Thu October 24, 2024

How to use the TOROW function

Thu October 24, 2024

How to use the WRAPCOLS function

Thu October 24, 2024

How to use the TAKE function

Thu October 24, 2024

How to use the DROP function

Thu October 24, 2024

How to use the CHOOSEROWS function

Thu October 24, 2024

How to use the EXPAND function

Thu October 24, 2024

How to use the CHOOSECOLS function

Wed October 23, 2024

How to use the HYPERLINK function

Wed October 23, 2024

Extract unique distinct values from an Excel Table filtered list

Wed October 23, 2024

List all hyperlinks in worksheet programmatically

Wed October 23, 2024

How to use the FREQUENCY function

Tue October 22, 2024

Sort rows based on frequency and criteria

Tue October 22, 2024

5 easy ways to extract Unique Distinct Values

Tue October 22, 2024

Working with unique values

Tue October 22, 2024

Dynamic scoreboard

Tue October 22, 2024

Follow stock market trends – Moving Average

Tue October 22, 2024

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

Mon October 21, 2024

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

Mon October 21, 2024

A beginners guide to Excel array formulas

Mon October 21, 2024

Plot date ranges in a calendar

Mon October 21, 2024

Highlight events in a yearly calendar

Mon October 21, 2024

VLOOKUP – Return multiple unique distinct values

Mon October 21, 2024

How to use the SUMPRODUCT function

Fri October 18, 2024

How to compare two data sets

Fri October 18, 2024

INDEX MATCH – multiple results

Fri October 18, 2024

Excel calendar

Thu October 17, 2024

Extract specific word based on position in cell value

Thu October 17, 2024

How to replace part of formula in all cells

Thu October 17, 2024

How to create date ranges in Excel

Thu October 17, 2024

Search for a sequence of values

Thu October 17, 2024

How to use the SCAN function

Thu October 17, 2024

How to use the GROUPBY function

Wed October 16, 2024

Extract unique distinct values sorted based on sum of adjacent values

Wed October 16, 2024

How to use the SORTBY function

Wed October 16, 2024

Advanced Date Highlighting Techniques in Excel

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