How to Sum or Count cells based on background color in Excel
This guide allows you how to get sum or count cells based on background color. It not only easier but also reduce…
#COUNTIF-Function
5 posts3 Ways to find duplicate values on same worksheet – Excel
Excel allows you to search or find duplicate values on same worksheet. You can use given three methods to identify the duplicate…
How to Identifying Duplicate Values in two Excel worksheets
Excel allows you to quickly search duplicate values in Excel. You can use given ways to identifying duplicate values in two excel…
How to compare data between two lists in Excel
Compare data between two lists sheet is an important thing. Excel allows you to compare two columns in Excel sheet with help…
How to use Countif function with wildcards in Excel
Countif function is used to count number of cells which meet the given single criteria. Countif function also support ? and *…