Results 1 to 4 of 4

Thread: Excel Data

  1. #1
    Neophyte babaty's Avatar
    Join Date
    Sep 2018
    Posts
    2
    Articles
    0
    Excel Version
    Excel 2016

    Excel Data



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hello there,
    Kindly help me with function/command that will arrange same value in the two columns given below:Thank you. ExcelData.xlsx
    Last edited by babaty; 2018-09-25 at 12:57 PM.

  2. #2
    Super Moderator NBVC's Avatar
    Join Date
    May 2011
    Location
    Mississauga, Canada
    Posts
    1,518
    Articles
    0
    Excel Version
    Excel 2016
    Your request is unclear. Please elaborate.


  3. #3
    Neophyte babaty's Avatar
    Join Date
    Sep 2018
    Posts
    2
    Articles
    0
    Excel Version
    Excel 2016
    Quote Originally Posted by NBVC View Post
    Your request is unclear. Please elaborate.
    I want arrange the values that exist in column VRS and INTS to be in same row. The values that do not exist should be deleted.

  4. #4
    Conjurer Logit's Avatar
    Join Date
    Nov 2016
    Posts
    254
    Articles
    0
    Excel Version
    2007
    .
    Here is a VBA Macro method :

    Code:
    Option Explicit
    
    
    
    
    Sub Listduplicates()
    'Updateby Extendoffice 20160613
        Dim rngA As Range
       
        Set rngA = Range([A1], Cells(Rows.Count, "A").End(xlUp))
        Application.ScreenUpdating = False
        rngA.Offset(0, 1).Columns.Insert
        
        With rngA.Offset(0, 1)
            .FormulaR1C1 = _
            "=IF(ISNA(MATCH(RC[-1],C[1],0)),"""",INDEX(C[1],MATCH(RC[-1],C[1],0)))"
            .Value = .Value
        End With
        
        Dim LR As Long
        LR = Range("B" & Rows.Count).End(xlUp).Row
        On Error Resume Next
        Range("B2:B" & LR).SpecialCells(xlCellTypeBlanks).EntireRow.Delete
        Range("B1").Value = "INTS"
        Sheets("Sheet1").Columns("C:C").Delete
        Application.ScreenUpdating = True
    End Sub
    Attached Files Attached Files
    Last edited by Logit; 2018-09-25 at 05:09 PM. Reason: Added code tags (needs slash not backslash)

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •