How to find duplicate values in Excel?
You can easily find all your duplicate values in a column with a simple formula and 2 Excel functions; FILTER and COUNTIF
COUNTIF
COUNTIFS – Count rows automatically in Excel
The COUNTIFS function in Excel works like a filter. It returns the number of rows you have in a worksheet based on one or more criteria.
Change the color of the weekends in Excel
In Excel, you can change the color of the weekend in your workbook by creating your custom rule in the conditional formatting tool.
Function COUNTIF
The COUNTIF function returns the number of rows within a range according to a criteria. Many situations are possible.
