how to count repetitive values from Excel

  • We cannot work from images, please attach your workbook, or an accurate example of it.

    We now have a reputation system in place. If my reply helped please "Like" the reply by clicking the "Like" icon at bottom right of my reply.

  • As an example, check below steps

    Often you might need to calculate the number of duplicates in your data without the first occurrence. You can count the number of duplicates excluding the first entry in the same way as the previous example. To count the duplicate examples from the last example without the first occurrence:

    Select cell F2.

    Assign the formula =COUNTIF($C$2:$C$8,E2)-1.

    Press Enter to apply the formula.

    This will help you,
    J Walter

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!