Sign in
Microsoft.com
 
Microsoft
 
 
 

locked
Excel 2007 Duplicate cells RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    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