Showing posts with label Duplication. Show all posts
Showing posts with label Duplication. Show all posts

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 No comments:
Labels:
Subscribe to: Posts (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...
  • Miscellaneous Exercise 2
    'Check filter is applied on the sheet or not if not apply filter on it Sub autofilteron() Sheet3.Activate If Not ActiveSheet.AutoFi...
  • WorkSheet
    'Worksheet Object 'Represents a worksheet. 'Remarks ' ' 'The Worksheet object is a member of the Worksheets co...