*thnks friends ,i was also looking this kind of solution
*Have A Nice Time & Enjoy Life
Regards:
CMA Ankur Pandey
(Someone Different)
I'm not the best but i'm not like the rest~~
On Thu, Feb 10, 2011 at 11:45 AM, hanumant shinde wrote:
> Hi Sudhir,
>
> i have done this using macro. please fin
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
To: Excel Group
Sent: Wed, 9 February, 2011 4:29:13 P
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
>
> --
> <>
