+ Reply to Thread
Results 1 to 5 of 5

how to remove duplicates and clean up contents

  1. #1
    Registered User
    Join Date
    05-25-2014
    Location
    ATHENS GREECE
    MS-Off Ver
    2007
    Posts
    58

    how to remove duplicates and clean up contents

    good morning everybody!
    i need your assistance please...in my sample xls,there are some contents (text) that i don't need.
    i'd like to remove the duplicate entries from the Consignee Address rows based on the contents of the Consignee City cells.
    what i mean? lets say, here,the word CHIOS shows 3 times,we dont need that,so we have to delete it in the Consignee Address,and leave it only in the Consignee City

    Shipment Number Consignee Consignee Address Consignee ZipCode Consignee City Consignee Phone Pieces Shipment Total Weight
    0866-03636276 MRS NELLH NIRI LEAFOROS AIGAIIOU 22 CHIOS CHIOS 82100 CHIOS 302023288 1 0.11



    so,the final text should be like this:
    Shipment Number Consignee Consignee Address Consignee ZipCode Consignee City Consignee Phone Pieces Shipment Total Weight
    0866-03636276 MRS NELLH NIRI LEAFOROS AIGAIIOU 22 82100 CHIOS 302023288 1 0.11


    in the second case,we have something like this:
    Shipment Number Consignee Consignee Address Consignee ZipCode Consignee City Consignee Phone Pieces Shipment Total Weight
    0866-03636453 MRS KRISTINA L. KALIVION 252 LAMIA -- SELECT STATE -- GR 35100 -- SELECT STATE -- 6954689 1 0.43

    here,we want to move the city (LAMIA) ,and replace the -- SELECT STATE -- in the to Consignee City

    please check the demo file,to see exactly what we need...
    DEMO.xlsx

    could someone help me achieve this with some macro?
    thank in advice!
    Still proud to be a Greek.....

  2. #2
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,987

    Re: how to remove duplicates and clean up contents

    For your second question

    Maybe you can do a VLookup on the zip code.
    Notice my main language is not English.

    I appreciate it, if you reply on my solution.

    If you are satisfied with the solution, please mark the question solved.

    You can add reputation by clicking on the star * add reputation.

  3. #3
    Registered User
    Join Date
    05-25-2014
    Location
    ATHENS GREECE
    MS-Off Ver
    2007
    Posts
    58

    Re: how to remove duplicates and clean up contents

    Good morning...please notice that i have no experiance in vba....so,any help would be appreciated!

  4. #4
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,987

    Re: how to remove duplicates and clean up contents

    It is no VBA code.

    VLookup is an excel formula.

  5. #5
    Registered User
    Join Date
    05-25-2014
    Location
    ATHENS GREECE
    MS-Off Ver
    2007
    Posts
    58

    Re: how to remove duplicates and clean up contents

    could someone be more specific? i'm absolut beginner in excel,and this file is needed to my job....i tried some things,but i cannot manage to solve it (nor understand exactly what to do...)
    sorry for being annoying....

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Need macro to remove duplicates from excel sheet after adding the contents
    By Amruta_chintalwar in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 04-19-2014, 06:43 PM
  2. [SOLVED] Remove multiple Carriage Returns - macro to clean cell contents
    By Deskjocky in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-03-2014, 01:52 PM
  3. [SOLVED] Remove #VALUE! and display a clean cell
    By JonathanVR in forum Excel General
    Replies: 1
    Last Post: 08-08-2012, 07:20 AM
  4. Conditional formatting to clean duplicates values?
    By sami770 in forum Excel General
    Replies: 9
    Last Post: 05-11-2011, 12:02 PM
  5. clean duplicates in list
    By frank101 in forum Excel General
    Replies: 1
    Last Post: 06-15-2005, 05:05 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1