How to Separate Date and Time in Different Columns

In this tutorial, you will learn how to separate Date and Time in different columns in Excel using the DATETIME function.

IF Statement Based on Cell Color

In this tutorial, I’ll show you how to write a formula using an IF Statement based on cell color in Excel using the COLORMATCH function.

How to extract word from string in Excel: first, last, or nth

This tutorial will show you straightforward ways to extract a word or words in Excel without using complex formulas.

How to separate first and last names in Excel

Learn how to separate names in Excel (first, last, or middle) using regular Excel formulas and advanced functions.

Excel substring: How to extract text from cell

Learn how to use the Excel SUBSTRING function to extract text before or after a character and find a substring surrounding a character.

Count rows that contain specific values

To count rows that contain specific values, apply the ROWCRT function or use a formula with the MMULT, TRANSPOSE, COLUMN, and SUM functions.

Count unique text values in a range

To count unique text values in a range, you can use a formula with the SUM and COUNTIF functions.

Get column totals

To get column totals of a range that contain numeric values, use the TOTALCOL function or a custom formula that uses the MMULT function.

Get row totals

To get row totals of a range that contain numeric values, use the TOTALROW function or a custom formula with the MMULT function.

Sum comma-separated values in Excel

To sum comma-separated values in Excel that are in a single cell, you can use the SUMCSV or FILTERXML functions.

Extract common values from two lists

You can use the Excel COMPARE function to extract common values from two lists and get the result into a dynamic array.

Count cells that do not contain errors

To count cells that do not contain errors, use the COUNTX function which works great with different data types in a given range.