Basic numeric sort formula in Excel
To dynamically sort data that contains only numeric values, you can use a helper column … Read More
Basic text sort formula in Excel
To dynamically sort text values in alphabetical order, you can use use a formula based … Read More
One way to track attendance using Excel formula
This tutorial shows b.asic attendance tracking formula in Excel
One way to track attendance is … Read More
Check if multiple cells have same value in Excel
To confirm that a range of cells all have the same value, you can use … Read More
Check multiple cells have same value in Excel
To confirm that a range of cells all have the same value, you can use … Read More
How to test for all values in a range are at least in Excel
To test if all values in a range are at least a certain threshold value, … Read More
How to retrieve first match between two ranges in Excel
To retrieve the first match in two ranges of values, you can use a formula … Read More
How to count specific words in a range in Excel
To count how many times a specific a word (or any substring) appears inside a … Read More
Count birthdays by month in Excel
This tutorial show how to Count birthdays by month in Excel using the example below.… Read More
Excel Rank without ties Example
This tutorials shows how to Rank numbers without ties in Excel.
To assign rank without … Read More
Excel Data validation unique values only
Reject duplicate data entry in a cell range.
To allow only unique values in a
Excel Data validation require unique number
Set criteria to accept only unique number, ie no duplicate.
To allow only unique numbers
Data validation must not exist in list
Accept data that are not included in a specific range of records
To allow only … Read More
Excel Data validation must begin with
Using the example below, this tutorial shows how to create Data validation must begin with … Read More
Excel Data validation exists in list
Using the example below, this tutorial shows how to create Data validation exists in list … Read More
Highlight unique values in Excel
This tutorial shows how to Highlight unique values in Excel using the example below;
Formula
… Read MoreHighlight duplicate rows in Excel
This tutorial shows how to Highlight duplicate rows in Excel using the example below;
Formula
… Read MoreHighlight duplicate values in Excel
This tutorial shows how to Highlight duplicate values in Excel using the example below;
Formula
… Read MoreHighlight missing values in Excel
This tutorial shows how to Highlight missing values in Excel using the example below;
Formula
… Read MoreHighlight cells that end with in Excel
This tutorial shows how to Highlight cells that end with in Excel using the example … Read More
- 1
- 2
- 3
- 4
- Next Page »