+ Reply to Thread
Results 1 to 4 of 4

how to filter the rows based on a column which contains duplicate values...

  1. #1
    Registered User
    Join Date
    08-19-2013
    Location
    Hyderabad
    MS-Off Ver
    Excel 2007, Excel 2010
    Posts
    1

    how to filter the rows based on a column which contains duplicate values...

    i want to filter the rows based on a column which contains duplicate values...

    for example based on column C which contains the values..(A,C,B,A,A,B,C,A,C,B)

    i want to filter the rows where column c value is equal to (A B C)

  2. #2
    Forum Expert XOR LX's Avatar
    Join Date
    04-18-2013
    Location
    Turin, Italy
    MS-Off Ver
    Office 365
    Posts
    7,742

    Re: how to filter the rows based on a column which contains duplicate values...

    Hi,

    I'm not sure you've been too clear in your request here. If column C contains single-letter entries such as A, B, C... then how is it possible to filter for entries, as you say, "equal to (A B C)"? (Is this a text entry consisting of A followed by space followed by B followed by space followed by C?)

    Regards
    Click * below if this answer helped

    Advanced Excel Techniques: http://excelxor.com/

  3. #3
    Registered User
    Join Date
    09-04-2013
    Location
    River State, Nigeria
    MS-Off Ver
    Excel 2010
    Posts
    1

    Re: how to filter the rows based on a column which contains duplicate values...

    Hi, on this same problem

  4. #4
    Forum Expert XOR LX's Avatar
    Join Date
    04-18-2013
    Location
    Turin, Italy
    MS-Off Ver
    Office 365
    Posts
    7,742

    Re: how to filter the rows based on a column which contains duplicate values...

    @Kasimir

    "Hi, on this same problem"

    Then perhaps you could explain in a little more detail?

    Regards

+ 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. [SOLVED] Filter rows based on unique values in one column + specific value in another column
    By Dieneces in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-31-2013, 09:55 AM
  2. Cut & paste rows based on duplicate column values
    By agolden7 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-26-2013, 11:09 AM
  3. Remove rows with duplicate values in one column based on value of another column
    By jolleyje in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 03-15-2013, 06:20 AM
  4. Replies: 5
    Last Post: 11-12-2012, 08:38 PM
  5. [SOLVED] Edit Recorded Macro to filter column with about 200k rows based on a list of values.
    By rocksan in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 04-19-2012, 03:35 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