Re: $$Excel-Macros$$ Query (Remove duplicate)

2012-03-19 Thread Venkat CV 
Hi Karan,
Try Advanced filter and select Unique records..And you can Copy and paste
it in New Column..

[image: Inline image 1]


*Best Regards,*
*Venkat *
*Chennai*
*My Linked in profile *


On Mon, Mar 19, 2012 at 1:07 PM, Karan Singh  wrote:

> Dear All,
>
> I need you assistance, I want to remove duplicate value from column A to
> B. I'v attached the test file. Kindly help me in this.
>
>
> Kaяan
>
>  
> 
>
>
>  --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>



-- 
*
*
*
*

-- 
FORUM RULES (986+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com
<>

Re: $$Excel-Macros$$ Query (Remove duplicate)

2012-03-19 Thread NOORAIN ANSARI 
Dear Karan,

Please use below code..

Dim i, j As Integer
Application.ScreenUpdating = False
For i = 1 To Range("A65536").End(xlUp).Row
For j = 1 To Range("B65536").End(xlUp).Row
If Range("A" & i).Value = Range("B" & j).Value Then
Range("B" & j).Delete Shift:=xlUp
End If
Next j
Next i
Application.ScreenUpdating = True



On Mon, Mar 19, 2012 at 1:07 PM, Karan Singh  wrote:

> Dear All,
>
> I need you assistance, I want to remove duplicate value from column A to
> B. I'v attached the test file. Kindly help me in this.
>
>
> Kaяan
>
>  
> 
>
>
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>



-- 
Thanks & regards,
Noorain Ansari
 *http://noorainansari.com/* 
*http://excelmacroworld.blogspot.com/*

-- 
FORUM RULES (986+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com


Query(Karan).xlsm
Description: application/vnd.ms-excel.sheet.macroenabled.12

Re: $$Excel-Macros$$ Query (Remove duplicate)

2012-03-19 Thread krishnanm2006 
Go to data- remove duplicates

Krishnan
Sent on my BlackBerry® from Vodafone

-Original Message-
From: Karan Singh 
Sender: excel-macros@googlegroups.com
Date: Mon, 19 Mar 2012 13:07:52 
To: 
Reply-To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Query (Remove duplicate)

Dear All,

I need you assistance, I want to remove duplicate value from column A to B.
I'v attached the test file. Kindly help me in this.


Kaяan

<http://www.facebook.com/singhkarann> <http://twitter.com/#%21/karan1237>
<https://plus.google.com/43524614789164919/posts>

-- 
FORUM RULES (986+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

-- 
FORUM RULES (986+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com