Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old March 18th 14, 09:54 AM
Junior Member
 
First recorded activity by ExcelBanter: Mar 2014
Posts: 1
Default Duplicate Help

Hey everyone, I'm having a problem working out an issue and I've tried using the duplicate tool but it doesn't seem to be working the way I want it to.

I have two lists of websites. List A is a full list and list B is over 60/70% of websites from List A that I have checked through.

Now I want to put the two lists together and leave only the unique websites. So if there a website listed twice, it would delete them both and it would leave me full of the websites that I haven't checked

  #2   Report Post  
Old April 18th 14, 09:14 AM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Apr 2014
Posts: 3
Default Duplicate Help

Hi

You can do using count if function as follows,

=countif(A1,$B$1:B1)


where A1 contains 1st List of website & column B contains list 2 of your websites name.

HTH//Cheers

On Tuesday, March 18, 2014 3:24:55 PM UTC+5:30, Eddng wrote:
Hey everyone, I'm having a problem working out an issue and I've tried

using the duplicate tool but it doesn't seem to be working the way I

want it to.



I have two lists of websites. List A is a full list and list B is over

60/70% of websites from List A that I have checked through.



Now I want to put the two lists together and leave only the unique

websites. So if there a website listed twice, it would delete them both

and it would leave me full of the websites that I haven't checked









--

Eddng




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Find duplicate, save in a list, delete duplicate using macro Erica[_3_] Excel Programming 1 January 27th 10 06:53 PM
VBA to delete Duplicate Records (1 column), before which, non-duplicate data merged into remaining row [email protected] Excel Programming 6 August 20th 09 02:40 AM
duplicate name help please Terry Excel Worksheet Functions 9 February 20th 08 03:52 PM
Duplicate Alam Excel Discussion (Misc queries) 2 December 3rd 07 07:30 AM
How do you delete duplicate addresses, but keep duplicate names? Shelly Excel Discussion (Misc queries) 1 August 28th 06 10:36 PM


All times are GMT +1. The time now is 05:13 AM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017