+ Reply to Thread
Results 1 to 2 of 2

unique record filter is not working only in this attached sheet

  1. #1
    Forum Contributor
    Join Date
    03-28-2008
    Location
    India, bangalore
    MS-Off Ver
    Excel 2003,2007
    Posts
    216

    unique record filter is not working only in this attached sheet

    Hi,

    I do know y advance filter is not working only in this attached sheet?

    can some one help to resolve this...

    Arvind
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    01-15-2007
    Location
    Brisbane, Australia
    MS-Off Ver
    2007
    Posts
    6,591
    Hi

    The entire data set is unique so it will bring back all records.

    Or do you only want the unique entries from column A? If so, then only select column A for your data range, nothing in the criteria, nominate the output cell, and select unique.

    rylo

+ 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. copying various cells in ot different cells in a different sheet
    By MonkeyDeath in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 07-25-2007, 11:22 AM
  2. Advanced Filter - Unique Records Only
    By pschultz in forum Excel General
    Replies: 0
    Last Post: 05-15-2007, 05:55 PM
  3. Advanced filter to show unique records
    By ResulG in forum Excel General
    Replies: 3
    Last Post: 12-04-2006, 09:06 AM
  4. VBA code to save only a sheet under a unique name
    By Jlong1980 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-30-2006, 10:03 PM

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