Hello Dear
You can use select to distinct.
If u want a proper macro for it reply me.
it is easy to select the distinct value only.
Assistance may be late,but we are helping our group after job.
Please Consider The Late Answer.
Happy to help
:)
Shyam
On Wed, Mar 10, 2010 at 8:17 PM, worawat kh <worawat...@gmail.com> wrote:
> Hi mono
>
> You can use pivot table by set e-mail to row and select data to count then
> you can copy only single e-mail that you wanted.
>
> *or *
>
> using simple macro mixed with pivo table like this
> 1. first you have to put you list in column A
> 2. Run macro as below code
>
> Sub DeleteDuplicate()
>
> Range(Selection, Selection.End(xlDown)).Select
> ActiveWorkbook.PivotCaches.Add(SourceType:=xlDatabase, SourceData:= _
> "Sheet1!R1C1:R65000C1").CreatePivotTable
> TableDestination:="[Book1]Sheet1!R1C3" _
> , TableName:="PivotTable1", DefaultVersion:=xlPivotTableVersion10
> ActiveSheet.PivotTables("PivotTable1").AddFields RowFields:="e-mail"
>
> ActiveSheet.PivotTables("PivotTable1").PivotFields("e-mail").Orientation = _
> xlDataField
> ActiveWorkbook.ShowPivotTableFieldList = False
> Application.CommandBars("PivotTable").Visible = False
> Range("C3:C21").Select
> Selection.Copy
> Range("F3").Select
> ActiveSheet.Paste
> Range("F2").Select
> Application.CutCopyMode = False
> ActiveCell.FormulaR1C1 = "E-mail"
> Columns("B:E").Select
> Selection.Delete Shift:=xlToLeft
> End Sub
>
>
> Hope it will help you
> Worawat
> *Excel beginner* <http://excelbeginner.blogspot.com>
>
>
>
>
>
> 2010/3/10 monu <manojibsp...@gmail.com>
>
> Hi
>>
>> I have a list of around 20 emails but there 4 to 5 thousand emails
>> which are repeated.
>>
>> Please tell me a macro which can delete the repeated row.
>>
>> Thanks
>>
>> --
>>
>> ----------------------------------------------------------------------------------
>> Some important links for excel users:
>> 1. Follow us on TWITTER for tips tricks and links :
>> http://twitter.com/exceldailytip
>> 2. Join our Facebook Group @
>> http://www.facebook.com/group.php?gid=287779555678
>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> <><><><><><><><><><><><><><><><><><><><><><>
>> HELP US GROW !!
>>
>> We reach over 6,800 subscribers worldwide and receive many nice notes
>> about the learning and support from the group.Let friends and co-workers
>> know they can subscribe to group at
>> http://groups.google.com/group/excel-macros/subscribe
>>
>
> --
>
> ----------------------------------------------------------------------------------
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our Facebook Group @
> http://www.facebook.com/group.php?gid=287779555678
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> HELP US GROW !!
>
> We reach over 6,800 subscribers worldwide and receive many nice notes about
> the learning and support from the group.Let friends and co-workers know they
> can subscribe to group at
> http://groups.google.com/group/excel-macros/subscribe
>
--
Thanks Regards
Shyam
Software Engineer
''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''
When one door of happiness closes, another opens;
but often we look so long at the closed door that we do not see the
one which has been opened for us.
- Helen Keller
''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''
Wenn eine Tür des Glücks schließt, öffnet sich ein weiteres,
aber oft schauen wir so lange auf die geschlossene Tür,
dass wir nicht sehen ein, die für uns geöffnet wurde. - Helen Keller
''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''
--
----------------------------------------------------------------------------------
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!
We reach over 6,800 subscribers worldwide and receive many nice notes about the
learning and support from the group.Let friends and co-workers know they can
subscribe to group at http://groups.google.com/group/excel-macros/subscribe
