+ Reply to Thread
Results 1 to 4 of 4

Filter data

  1. #1
    Registered User
    Join Date
    12-04-2013
    Location
    Melbourne
    MS-Off Ver
    Excel 2007
    Posts
    92

    Filter data

    Hi,

    I have a table with some data. I want to filter duplicate names for each sitee. I have explained what i want to do in excel sheet attched bellow. Any help is much appriciated.


    Thank you
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    10-09-2012
    Location
    Dallas, Texas
    MS-Off Ver
    MO 2010 & 2013
    Posts
    3,049

    Re: Filter data

    You can create a helper column with countif to see if it is a duplicate?
    Please ensure you mark your thread as Solved once it is. Click here to see how.
    If a post helps, please don't forget to add to our reputation by clicking the star icon in the bottom left-hand corner of a post.

  3. #3
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,378

    Re: Filter data

    Hi tharindudk,

    Perhaps you should edit your example?
    If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)

    You can't do one thing. XLAdept

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin

  4. #4
    Registered User
    Join Date
    12-04-2013
    Location
    Melbourne
    MS-Off Ver
    Excel 2007
    Posts
    92

    Re: Filter data

    HI,

    Is there a way to write
    Please Login or Register  to view this content.
    in a propper way. because what i am trying to do is scan range between site_1:site_2, Then site2:site3 etc.

+ 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. Replies: 0
    Last Post: 01-16-2014, 10:55 AM
  2. Replies: 2
    Last Post: 10-07-2013, 04:57 AM
  3. [SOLVED] Filter issue: data does not appear in filter box
    By Madmortagan68 in forum Excel General
    Replies: 2
    Last Post: 04-15-2013, 01:00 PM
  4. Second Advanced Filter does not work based on the data generated from the filter
    By mucc1928 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-29-2011, 02:42 PM
  5. in data/filter/auto filter
    By sp8 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-11-2006, 08:10 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