Hi Sudhir, i have done this using macro. please find the attached. 1. paste your data in col "A" from row 1 2. in sheet 2 there is 1 button click on it. you will get the desired result.
________________________________
From: sudhir kumar <bluecore...@gmail.com>
To: Excel Group <excel-macros@googlegroups.com>
Sent: Wed, 9 February, 2011 4:29:13 PM
Subject: $$Excel-Macros$$ Shorting Problems
Dear Frnd
I have list which have many repeated names
i want short it with formula
thanx
--
<><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><>
Sudhir VermaAsstt. Mngr. A/c's
9818479722
P think Before you print
Life is Very beautiful !!!
¨`•.•´¨) Always
`•.¸(¨`•.•´¨) Keep
(¨`•.•´¨)¸.•´ Smiling!
`•.¸.•´.
Happy Valentine Day
\ ¦ /
(ò ó)
_____ ___o0o___(_)___o0o__
___¦_____¦_____¦_____¦_____¦
¦_____¦_____¦_____¦_____¦__
___¦_____¦_____¦_____¦_____¦
--
----------------------------------------------------------------------------------
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
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
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel
--
----------------------------------------------------------------------------------
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
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
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel
Remove Duplicate.xlsm
Description: Binary data
