locked
Excel 2007 Duplicate cells RRS feed

  • Question

  • Hi, I don’t know how to create a formula to do the sample below. Any help will be appreciating?

    Thanks

     Compare cells G and H with cell E if duplicates are found with different E values leave alone, if duplicate are found but with a unique values on column E cut the entire line and past into a new worksheet?

    Example:

    Column E = Branch

    Column G = Sales Order

    Column H = Line

    The sample that is going to be cut and past is going to be SO 92349

    Branch                   

    Sales Order        

    Line               

    A

    81178

    1

    P

    81178

    1

    A

    92349

    1

    A

    92972

    1

    P

    92972

    1

    Thursday, May 5, 2011 2:37 PM