In Excel, we can make values appear in a specific range by using Conditional Formatting or Formulas. Conditional formatting is a built in feature of Excel while formulas are flexible enough to fulfil our requirement.
We can use the "COUNTIF"function to return the output.
Countif: Counts the number of cells within a range that meets the condition.
range: It refers to the range of selected cells from which the function will check the number of items that have found.
criteria: The condition which defines / specifies which cells to count.
Let us take an example:
We have some random numbers in column A & few of them are duplicate.
The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.