How to check entries in a column for duplicates in Excel
For this example, we are going to implement a formula to check for duplicate entries while data is being entered into a column. To achieve this task, we will be using the COUNTIF function. Also, each time a duplicate entry is found, we will display a confirmation in an adjacent column. Here are the steps:
We [...]
Calculate attendance figure in Excel using the COUNTIF function
This example should be useful if you deal with a lot of attendance figures and would like to track attendance in a more efficient way. We are presented with an attendance register and are asked to calculate the number of persons present on any given day as well as calculate how many times a person [...]
How to use the COUNTIF function to count values in Excel
In this example, we will be using the COUNTIF function to count specific values in a worksheet. We will be using a price list and will try to determine how many products in the price list cost more than $500. The COUNTIF function will count the number of cells in a range that meet this [...]
