+ Reply to Thread
Results 1 to 4 of 4

One of each unique cells

  1. 04-19-2012, 06:50 AM #1
    mrcois
    mrcois is offline
    Forum Contributor
    Join Date
    04-20-2010
    Location
    Pretoria, South Africa
    MS-Off Ver
    Excel 2016
    Posts
    151

    One of each unique cells

    I want a formula to scan through Column A and select one of each unique cells. Please see attached document!
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 04-19-2012, 06:55 AM #2
    Mallycat
    Mallycat is offline
    Valued Forum Contributor
    Join Date
    06-16-2006
    Location
    Sydney, Australia
    MS-Off Ver
    2013 64bit
    Posts
    1,394

    Re: One of each unique cells

    Use an advanced filter, turn on the "unique records" switch
    Reply With QuoteRegister To Reply
  3. 04-19-2012, 06:57 AM #3
    mrcois
    mrcois is offline
    Forum Contributor
    Join Date
    04-20-2010
    Location
    Pretoria, South Africa
    MS-Off Ver
    Excel 2016
    Posts
    151

    Re: One of each unique cells

    How can I do this without the Advanced filter? I am creating a template document where data has to be copied in and therefore have to exclude the Advanced Unique filter on.
    Reply With QuoteRegister To Reply
  4. 04-19-2012, 06:59 AM #4
    tom1977
    tom1977 is offline
    Forum Expert
    Join Date
    09-27-2011
    Location
    Poland
    MS-Off Ver
    Excel 2007
    Posts
    1,312

    Re: One of each unique cells

    Hi try attachment
    Attached Files Attached Files
    Regards

    tom1977

    If You are satisfied with my solution click the small star icon on the left to say thanks.
    Reply With QuoteRegister To Reply
+ 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)

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.6.0 RC 1