his 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
> *To:* Excel Group
> *Sent:*
11 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
--
<><><><><><><><><><><><><><><><><><>&
Hi Sudhir,
please find the attachment and check it,
On Wed, Feb 9, 2011 at 4:29 PM, sudhir kumar wrote:
> Dear Frnd
>
> I have list which have many repeated names
> i want short it with formula
>
>
> thanx
>
> --
> <><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><>
> Sudhir Verma
Hi Sudhir,
Select the row A => Click on Data Tab => Click on Advanced => Select Unique
Records Only. That's it.
Regards
Umesh
On Wed, Feb 9, 2011 at 4:29 PM, sudhir kumar wrote:
> Dear Frnd
>
> I have list which have many repeated names
> i want short it with formula
>
>
> thanx
>
> --
> <>
Dear Frnd
I have list which have many repeated names
i want short it with formula
thanx
--
<><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><>
Sudhir Verma
Asstt. Mngr. A/c's
9818479722
*
P think Before you print
*
*
**
Life is Very beautiful !!!
*
*
¨`•.•´¨) Always
`•.¸(¨`•.•´¨) Ke
