+ Reply to Thread
Results 1 to 5 of 5

Remove duplicate values in Field cell from same column

  1. #1
    Forum Contributor
    Join Date
    09-01-2008
    Location
    Australia
    Posts
    108

    Remove duplicate values in Field cell from same column

    Hi All,
    I am trying to remove duplicate values from cells in 1 column but to no available.
    The duplicate fields would be removed and replaced back to Column A.
    Try below but does not work.
    Any help would be appreciated.

    HTML Code: 
    Regards,
    Nironto
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    12-10-2006
    Location
    Sydney
    MS-Off Ver
    Office 365
    Posts
    3,523

    Re: Remove duplicate values in Field cell from same column

    Hi nironto,

    Here's one way:

    Please Login or Register  to view this content.
    Regards,

    Robert
    ____________________________________________
    Please ensure you mark your thread as Solved once it is. Click here to see how
    If this post helps, please don't forget to say thanks by clicking the star icon in the bottom left-hand corner of my post

  3. #3
    Forum Contributor
    Join Date
    11-21-2015
    Location
    Philippines
    MS-Off Ver
    Microsoft Office 2016
    Posts
    146

    Re: Remove duplicate values in Field cell from same column

    Please Login or Register  to view this content.
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Attached Files Attached Files

  4. #4
    Forum Contributor
    Join Date
    09-01-2008
    Location
    Australia
    Posts
    108

    Re: Remove duplicate values in Field cell from same column

    Thanks Robert!
    It works!

    Regards,
    Nironto

  5. #5
    Forum Expert
    Join Date
    12-10-2006
    Location
    Sydney
    MS-Off Ver
    Office 365
    Posts
    3,523

    Re: Remove duplicate values in Field cell from same column

    Thanks Robert!
    It works!
    That's great - always extra glad to help a fellow Aussie

    Thanks for marking the thread as solved and for the rep

    Regards,

    Robert

+ 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. Macro to remove duplicate values from cell
    By Hypex in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-23-2016, 05:34 PM
  2. [SOLVED] How to sum duplicate values then remove the duplicate rows?
    By terry3218 in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 12-12-2015, 02:38 AM
  3. [HELP] me to remove duplicate values and leave that cell as blank
    By spa3212 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-30-2015, 01:23 PM
  4. [HELP] me to remove duplicate values and leave that cell as blank
    By spa3212 in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 04-30-2015, 12:55 AM
  5. Formula or code to remove duplicate text or values within a cell
    By winmaxservices1 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 12-22-2014, 06:16 AM
  6. Replies: 1
    Last Post: 11-14-2014, 07:45 PM
  7. Remove rows with duplicate values in one column based on value of another column
    By jolleyje in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 03-15-2013, 06:20 AM

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