+ Reply to Thread
Results 1 to 2 of 2

Thread: How do I remove repetitions in a column?

  1. 10-07-2008, 02:54 PM #1
    Stretch617
    Stretch617 is offline
    Registered User
    Join Date
    10-07-2008
    Location
    Grand Cayman
    Posts
    12

    How do I remove repetitions in a column?

    Hi, I have a column of info that has many fields repeated. Is there a function or a way to remove the repetitions so that I am left with a clean list and can then use this to do a vlookup on a corresponding spread sheet?

    Thanks for your time and response
    Last edited by Stretch617; 10-08-2008 at 12:52 PM. Reason: Typo
    Reply With Quote Reply With Quote
  2. 10-07-2008, 03:05 PM #2
    VBA Noob
    VBA Noob is offline
    Forum Guru VBA Noob's Avatar
    Join Date
    04-25-2006
    Location
    London, England
    MS-Off Ver
    xl03 & xl 07(Jan 09)
    Posts
    12,010
    See if link helps

    http://www.contextures.com/xladvfilter01.html#FilterUR

    VBA Noob
    _________________________________________


    Credo Elvem ipsum etian vivere
    _________________________________________
    A message for cross posters

    Please remember to wrap code.

    Forum Rules

    Please add to your signature if you found this link helpful. Excel links !!!
    Reply With Quote Reply With Quote
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Macro for coding an action based on 3 columns of information
    By chozen86 in forum Excel Programming
    Replies: 6
    Last Post: 07-31-2008, 10:44 PM
  2. need formula for C:1 to add column C rows that equal value in A:1 in column A
    By cosmicgrooves in forum Excel Worksheet Functions
    Replies: 5
    Last Post: 07-18-2008, 07:35 PM
  3. finding last used column in range
    By inky in forum Excel Worksheet Functions
    Replies: 2
    Last Post: 02-07-2008, 05:29 AM
  4. Can we removing particular rows of data thru formulas?
    By gsmonk in forum Excel General
    Replies: 5
    Last Post: 09-17-2007, 11:16 AM
  5. Remove lines without a value in column M?
    By Claude-Smith in forum Excel General
    Replies: 4
    Last Post: 09-05-2007, 09:51 AM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.2.0