formula to compare a complete row to other row finding duplicates row

  • My data
    1 A B
    A F V G
    1 A B
    I need a formula that can find a duplicate row or let me know that there is a duplicate row here 1 and 3 is same

  • Re: formula to compare a complete row to other row finding duplicates row


    In what way is this thread different to the one you have running below?


    http://www.ozgrid.com/forum/showthread.php?t=203681


    Please let me know. Thanks!

    Ali :)


    Enthusiastic self-taught user of MS Excel who's always learning!
    If anyone has helped you towards solving a problem, then you can thank them by clicking on the like icon bottom right.

    :!:Forum Rules

  • Re: formula to compare a complete row to other row finding duplicates row


    Having looked carefully at your other thread, and in the absence of a response from you here, I have concluded that this is the same query again. Please continue in your original thread - you can 'bump' the thread, if necessary. Thanks.

    Ali :)


    Enthusiastic self-taught user of MS Excel who's always learning!
    If anyone has helped you towards solving a problem, then you can thank them by clicking on the like icon bottom right.

    :!:Forum Rules

Participate now!

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