Results 1 to 16 of 16

Remove duplicates from list

Threaded View

  1. #1
    Forum Expert
    Join Date
    04-23-2009
    Location
    Matrouh, Egypt
    MS-Off Ver
    Excel 2013
    Posts
    6,892

    Remove duplicates from list

    Hello everybody
    I have values in Range("G4:G79") There are duplicates for every value ..
    I want to get rid of duplicates except for the first value
    for example : In range("G4:G22") there is the value 15 I want to clear all the values of 15 except the first which is in G4 and so on for the rest of values
    And if the value is unique remains as it ..
    The results should be in its place not to collect all uniques ...
    G4 = 15 and blank cells till G23 =20
    Here's an attachment
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Formula to remove duplicates from a list
    By AK262007 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 04-04-2014, 04:56 AM
  2. List Duplicates (Don't Remove)
    By Imran688 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-15-2012, 08:13 AM
  3. Remove duplicates from 2nd list
    By skins in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 06-01-2011, 10:41 AM
  4. Replies: 1
    Last Post: 01-07-2011, 04:06 PM
  5. [SOLVED] How to remove duplicates from a list and copy new list to new colu
    By Chance in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-23-2005, 01:07 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