Formula to compare 2 new lists and return a Value

    Hi Guys, I am looking for a formula rather than VBA to compare 2 lists and return a value.


    I want to compare List B to List A and return the number of New Values in List B. (Answer should be 5).
    It cant be just be a count of List A v List B as it is possbile that some of the items might be deleted from list b.


    I can get around it by adding in an extra column, do a vlookup and then count the number of "false" values but would prefer not to add the extra column as I am only intested in the final number.


    I hope that makes sense, can anyone help please?


    cheers

    Re: Formula to compare 2 new lists and return a Value


    As per your worksheet data. I tried using this formula .


    =SUMPRODUCT(--ISERROR((MATCH($C$3:$C$16,$A$3:$A$11,0))))


    [COLOR="#0000CD"]MODERATOR EDIT[/COLOR]
    Please do not quote entire posts. When quoting follow these guidelines


    1. Quote ONLY if it is needed to add clarity or context for your reply. If so, then
    2. Quote ONLY the specific part of the post that is relevant - - not the entire post.


    This will keep thread clutter to a minimum and make the discussion easier to follow. Quote deleted.
    Thanks

    Re: Formula to compare 2 new lists and return a Value


    Thanks very much for the reply I have tried the function and am getting a value returned but not sure what it is giving me its not the correct answer and its not obvious what it is returning I will investigate a bit more and feed back.

Participate now!

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

Register Yourself Login