Go to the Data Tab and on the 'Data Tools' group select remove duplicates.
This will work for Excel 2007+
On Thursday, November 22, 2012 10:19:18 AM UTC-4, Manjunath Narayanappa
wrote:
>
> Dear Team,
>
>
>
> In the above attached Spreadsheet, I have more than 3777 row in which
> Column C has
HI Manjunath ,
Public Sub RemoveDuplicate()
Dim varArrData As Variant
Dim lngRow As Long
Dim dicData As Dictionary
Dim strKey As String
Set dicData = New Dictionary
dicData.CompareMode = TextCompare
With ThisWorkbook.Worksheets("Sheet1
Hi Prince,
>From all the column…
Thanks
Manjunath
From: Prince [mailto:prince141...@gmail.com]
Sent: 22 November 2012 16:27
To: excel-macros@googlegroups.com
Cc: Manjunath Narayanappa
Subject: Re: REmove duplicate entries
Hi Manjunath,
Do you want to remove duplicates from C column only or fro
Hi Manjunath,
Do you want to remove duplicates from C column only or from all columns.
Regards
Prince
On Thursday, November 22, 2012 7:49:18 PM UTC+5:30, Manjunath Narayanappa
wrote:
>
> Dear Team,
>
>
>
> In the above attached Spreadsheet, I have more than 3777 row in which
> Column C has
