Post Project
  • Search
    • Buyers can
    • Search offers to buy now
    • Search freelancers to request a proposal
    • Freelancers can
    • Search projects to quote on
  • How it works
  • Log in
  • Sign up
  • Freelancer?
Browse by Category
    Technology & ProgrammingWriting & TranslationDesignDigital MarketingVideo, Photo & ImageBusinessMusic & AudioMarketing, Branding & SalesSocial Media

    Microsoft Excel: Remove Duplicate Address but Keep Names

    - or -

    Post a project like this
    1720
    $25
    • Posted: 5 years ago
    • Proposals: 24
    • Remote
    • #2033899
    • Awarded
    HUMAYOON S.
    HUMAYOON S.
    Microsoft Excel / Google Spreadsheet / IBM SPSS Professional
    Top Endorsed
    Pakistan Karachi
    The Taj ..
    The Taj ..
    Data scraping / data mining / data extraction / web scraping / scraping / data conversion / General admin support and more
    Top Endorsed
    United States Kent
    Ken O.
    Ken O.
    Web Design, Data Entry and SEO Expert
    Top Endorsed
    Nigeria Zuru
    Rana K.
    Rana K.
    .NET | PHP | WordPress Theme/Plugins Developer | UI/UX & Graphic Designer
    India Kolkata
    Shikshaa S.
    Shikshaa S.
    6+ Years Experienced Web Developer & Graphic Designer
    Top Endorsed
    India Indore
    IK Accountants & Tax Consultants
    IK Accountants & Tax Consultants
    Chartered Certified Accountant
    Top Endorsed
    Reunion Trois-Bassins
    Alex B.
    Alex B.
    Experienced with Admin & Data Entry duties.
    Top Endorsed
    United Kingdom City of London
    Obaid U.
    Obaid U.
    Microsoft Certified Advance Excel Specialist¦Power BI consultant ¦ (ACCA)- Chartered Certified Accountant ¦ Accounting- Reconciliations ¦DAX ¦Data Models ¦Excel related any Work¦Macros of Excel¦
    Top Endorsed
    Qatar Doha
    AYESHA A.
    AYESHA A.
    Data Entry Operator
    Top Endorsed
    Bangladesh Chittagong
    Lorena C.
    Lorena C.
    Virtual Assistant
    Spain Velez-Malaga
    Ashish P.
    Ashish P.
    Data Scraping Expert - Web Scraping - Data Research - E-commerce Solution - All type of admin task
    Top Endorsed
    India New Delhi
    Uzair A.
    Uzair A.
    CV Writer ✮ Resume Writer ✮ Graphics Designer ✮ Software Developer
    Top Endorsed
    Pakistan Islamabad
    • 1
    • 2
    1267140139058495724564804679927930594101625214064161473077153899618568591907118
    HUMAYOON S.
    The Taj ..Ken O.Rana K.Shikshaa S. + 19 others have already sent a proposal.
    • 11
    • 11

    Description

    Experience Level: Intermediate
    Have an Excel list with about 7623 names and addresses. However most of those addresses are duplicates because of multiple people living at the address. I want to remove the duplicate addresses but keep the names of the individuals living in the home in the first name column only, leaving the last name column blank.

    Eg:
    John Smith, 123 Smith Road
    Vernon Johnson, 123 Smith Road
    James Adams, 123 Smith Road

    John Smith
    Vernon Johnson
    James Adams
    123 Smith Road
    Yrneh E.
    Yrneh E.
    93% (3)
    Projects Completed
    2
    Freelancers worked with
    2
    Projects awarded
    43%
    Last project
    17 Jul 2019
    United States

    New Proposal

    Login to your account and send a proposal now to get this project.

    Log in

    Clarification Board Ask a Question

    • 04 Jun 2018Humaira Y.

      hello Yrneh E
      if this job is still available then let me know. i will do this project within few hours
      thanks

    653885
    1720
    $25

    - or -

    Post a project like this
    Yrneh E.
    Yrneh E.
    93% (3)
    Projects Completed
    2
    Freelancers worked with
    2
    Projects awarded
    43%
    Last project
    17 Jul 2019
    United States

    Related project Searches


    microsoft (ms)

    Product

    • About
    • Team
    • Careers

    Support

    • How it works
    • Trust & Safety
    • Help Centre

    Discover

    • GuidesStoriesNews

    Resources

    • Customer Stories
    • Business Cost Calculator
    • Startup Cities

    Browse

    • Freelance Services
    • Freelance Services By Country
    • Freelance Skills
    • Terms
    • Privacy
    • Sitemap
    • Company Details
    • © 2023 People Per Hour Ltd
    We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
    Cookie Settings
    Accept All Cookies