What is MATCH function in Excel?
MATCH function is one of Lookup and Reference functions … 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
How to calculate two-way lookup VLOOKUP in Excel Table
To do a two-way lookup in an Excel Table, you can use the MATCH function … Read More
Example of COUNTIFS with variable table column in Excel
To use COUNTIFS with a variable table column, you can use INDEX and MATCH to … Read More
Get column index in Excel Table
To get the index of a column in an Excel Table, you can use the … Read More
Check if range contains a value not in another range in Excel
To test if a range contains any values (i.e. at least one value) not in … Read More
How to get last row in text data in Excel
To get the last relative position (i.e. last row, last column) for text data (with … Read More
How to get last row in numeric data in Excel
To get the last relative position (i.e. last row, last column) for numeric data (with … Read More
How to get last row in mixed data with blanks in Excel
To get the last relative position (i.e. last row, last column) for mixed data that … 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 generate random number weighted probability in Excel
To generated a random number, weighted with a given probability, you can use a helper … Read More
Find most frequent text within a range with criteria in Excel
To find the most frequently occurring text in a range, based on criteria you supply, … Read More
Extract most frequently occurring text in Excel
To extract the word or text value that occurs most frequently in a range, you … Read More
How to calculate next scheduled event in Excel
To get the next scheduled event from a list of events with dates, you can … Read More
Get work hours between dates custom schedule in Excel
To calculate work hours between two dates with a custom schedule, you can use a … Read More
How to abbreviate names or words in Excel
To abbreviate text that contains capital letters, you can try this array formula based on … Read More
Excel Data validation specific characters only
Set criteria to accept specific characters only
To use data validation to allow a list
Highlight approximate match lookup conditional formatting in Excel
This tutorial shows how to Highlight approximate match lookup conditional formatting in Excel using the … Read More
Categorize text with keywords in Excel
This tutorial shows how to Categorize text with keywords in Excel using the example below;… Read More
Two-way lookup with INDEX and MATCH in Excel
This tutorial shows how to calculate Two-way lookup with INDEX and MATCH in Excel using … Read More
Two-way lookup with VLOOKUP in Excel
This tutorial shows how to calculate Two-way lookup with VLOOKUP in Excel using the example … Read More
- 1
- 2
- 3
- 4
- Next Page »