COUNTIF function is one of the most useful functions in Excel. Its job is to provide conditional counting. This is primarily used for analysing data and producing reports and dashboards.
In this blog post we look into 5 more unorthodox but useful scenarios for the
COUNTIF function to be used. The 5
COUNTIF examples we look at are:
- Prevent duplicates in a range.
- Uniquely rank items in a list.
- Count the unique entries in a list.
- Compare two lists.
- Identify names that occur 3 times or more.
Full article: 5 alternative reasons to use COUNTIF function