Wednesday, March 15, 2017

Remove Duplicate Record from a Column

Months Units Sold
Jan 174
Feb 161
Mar 126
May 159
Jun 174
Jul 171
Sep 131
Oct 84
Dec 177
Jan 174
Feb 161
Jan 126
Jan 159
Mar 174
Feb 171
Mar 131
Jan 84
Feb 177

Sub Remove_Duplicate()

    Range("A1:B19").RemoveDuplicates Columns:=1, Header:=xlYes
    
End Sub

at
Labels:

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

*INTERVIEW QUESTIONS

* Ques 01. What is the difference between ByVal and ByRef and which is default ? Ans-  ByRef : If you pass an argument by reference when...

  • Text File
    ''TextStream Object ' 'Description ' 'Facilitates sequential access to file. ' 'Syntax ' 'T...
  • Object Variable
    'Object variable not set (Error 91) ' 'There are two steps to creating an object variable. First you must declare the object ...
  • File System Object
    'FileSystemObject Object ' 'Description ' 'Provides access to a computer's file system. ' 'Syntax ...