Use the INDEX, MATCH, and LARGE functions to determine the best salesperson
As illustrated earlier, it is easy to find out the highest value in a list. But how do you find the one person on a sales team who sold the most? And how do you find out how much ahead of the others he or she is? Start with the LARGE function to determine the [...]
Using the EXACT function to compare two columns in Excel
Previously, we created a tutorial on how to compare two columns using the IF Function, you can view that tutorial HERE. The difference between both methods is that by using the EXACT Function, it will be able to distinguish between upper- and lowercase characters, while using the previous method cannot. Here is the syntax for [...]
Identify missing numbers in a consecutive list using Excel
For this example, we have a list of a numbers in Column A and we’d like to check if there are any missing values assuming that they are supposed to be consecutive values, i.e., from 1-10 or from 234 - 456.
For this example, all of our values are listed from cells A1:A10 and we will [...]
