Removing Duplicate Columns

[psycoperl]

I was wondering if there was a way to automatically remove duplicate columns like there is to do with rows?

 

[zero269]

Excel has a built-in Remove Duplicates tool that might interest you:

Filter for unique values or remove duplicate values - Microsoft Support

How to filter for unique values in Excel, remove duplicate values, and more.

support.microsoft.com

Find and remove duplicates - Microsoft Support

How to find and remove duplicates in Excel. Filter for unique values in large or small datasets to clean up your worksheets and workbooks.

support.microsoft.com

 

[Herakles]

Try this on a copy of your data.

Call this procedure using the following line:

Call subDeleteDuplicateColumns(Worksheets("DuplicateColumns"))

Substitute the worksheet name as appropriate.

Public Sub subDeleteDuplicateColumns(WsData As Worksheet)
Dim intColumns As Integer
Dim strColumns As String
Dim arr() As String
Dim x As Integer
    
    intColumns = WsData.Range("A1").CurrentRegion.Columns.Count
         
    WsData.Rows(2).Insert
    
    With WsData.Range("B2").Resize(1, intColumns - 1)
        .Formula = "=IF(COUNTIF($A$1:B1,B$1)>1,COLUMN()," & """""" & ")"
        .Value = .Value
    End With
        
    With WsData
        arr = Split(Application.WorksheetFunction.TextJoin(",", True, .Cells(2, 2).Resize(1, intColumns - 1)), ",")
        .Rows(2).Delete
        For x = UBound(arr) To LBound(arr) Step -1
            .Cells(1, Val(arr(x))).EntireColumn.Delete
        Next x
    End With
    
End Sub

 

[Peter_SSs]

Excel has a built-in Remove Duplicates tool that might interest you:

Perhaps you missed these bits of information? It seems the OP already knows about Remove Duplicates for rows.

remove duplicate columns like there is to do with rows?

 

[psycoperl]

good morning all -
I ended up creating a new sheet and pasting & transforming to rows. Then ran remove duplicates and then redid the transforming back to columns.
I wish that Excel would just have the ability to check for duplicate columns. Just like they can sort columns as well as rows.

 

[Herakles]

Did you try using the code that I posted?

Having duplicate rows is much more likely than having duplicate columns. I'm not sure how
the latter would come about.

VBA is there to supplement what Excel provides.