Posts by Jameswalter

    When VLOOKUP can't find a value in a lookup table, it returns the #N/A error. You can use the IFNA function or IFERROR function to trap this error. However, when the result in a lookup table is an empty cell, no error is thrown, VLOOKUP simply returns a zero.

    Hope this helps,
    J Wick

    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