excel vba duplicate rows

  1. E

    VBA: Delete Duplicate Values on Condition

    Hi All, Please help me with this. I have a sheet with Column A(ID e.g. 1111-2222-3333-4444) and Column B(Status e.g. Installed, Inactive, Cancelled). It has several duplicates on both columns. My goal is to have only one ID and if there is Installed status amongst the duplicates it has to be...
  2. D

    create multiple entries from each row (truncating rest of row)

    I have a spreadsheet with 4 columns of information, then a column for a primary name, and then many columns of secondary names (with a different number of secondary names for each row). For rows with more than 1 secondary name, I need to create a new row with a copy of all the columns up to...

Some videos you may like

This Week's Hot Topics