Excel Tips: Calculation & Formulas > User Defined Functions

Insert

How to check if a pivot table exists in a workbook?

How to display table or pivot table name in a cell in Excel?

How to extract actual addresses from hyperlinks in Excel?

How to generate all prime numbers between two given numbers in Excel?

How to get list of sheets names in Google sheets?

Format

How to convert date to ordinal date format in Excel?

How to determine and identify the background color index of cells in Excel?

How to display row height or column width in cells?

How to format number as ordinal (1st 2nd 3rd ) in Excel?

How to highlight / conditional formatting cells with formulas in Excel?

How to highlight cells with external links in Excel?

How to pad IP address with zero in Excel?

Data

How to check if a sheet exists in a workbook?

How to check if the number is prime number in Excel?

How to display / show auto filter criteria in Excel?

How to filter cells with comments in Excel?

How to filter cells with formulas in Excel?

How to filter data by multiple colors in Excel?

How to filter rows based on cell color in Google sheet?

How to sort cells by last character or number in Excel?

How to sort data by case sensitive in Excel?

How to sort numbers with text/letter prefix or suffix in Excel?

How to sort numbers within a cell in Excel?

How to sort or filter data by strikethrough in Excel?

Others

How to check if a folder path exists in Excel?

How to convert column letter to number or vice versa in Excel?

How to convert comments to cell contents in Excel?

How to easily extract comments contents in Excel?

How to play a sound if a condition is met in Excel?

How to use/reference value from previous worksheet in Excel?