+ Reply to Thread
Results 1 to 9 of 9

Newbie question on manipulating list data

  1. #1
    Registered User
    Join Date
    01-31-2007
    Posts
    5

    Newbie question on manipulating list data

    Hello,

    Given a list, suppose I want to keep all rows that have a non-unique column A value?
    For example, given

    A1 A2 A3
    Toyota blue 4
    Toyota red 3
    Toyota green 2
    Ford blue 3

    I want to keep the three rows with "Toyota" in Column A. The opposite effect of the "unique" function, that is.

    Thank you in advance.

  2. #2
    Forum Expert Carim's Avatar
    Join Date
    04-07-2006
    Posts
    4,070
    Hi,

    Try Data Filter AutoFilter ...
    HTH
    Carim


    Top Excel Links

  3. #3
    Registered User
    Join Date
    01-31-2007
    Posts
    5

    and then what?

    Data -> Filter -> Autofilter

    and then what?

  4. #4
    Forum Expert Carim's Avatar
    Join Date
    04-07-2006
    Posts
    4,070
    See attached ...
    Attached Files Attached Files

  5. #5
    Registered User
    Join Date
    01-31-2007
    Posts
    5

    ?

    Thanks for the spreadsheet. I still do not know what to do. Is there a macro in that sheet that I should use?

  6. #6
    Registered User
    Join Date
    01-31-2007
    Posts
    5

    more detail

    I should add that the sheet Iam looking at has thousands of rows, each keyed by an integer ID in column 1. I need to keep the rows that have an ID in common with at least one other row

  7. #7
    Forum Expert Carim's Avatar
    Join Date
    04-07-2006
    Posts
    4,070
    There is no macro ...
    You can select your field in the dropdown box ...

  8. #8
    Registered User
    Join Date
    01-31-2007
    Posts
    5

    continuing...

    If my data looked like

    Toyota blue 2
    Toyota red 4
    Toyota green 4
    Ford blue 4
    Audi red 2
    Audi blue 4

    I want this as my result:

    Toyota blue 2
    Toyota red 4
    Toyota green 4
    Audi red 2
    Audi blue 4

    I would select "Toyota" and then "Audi" from the drop down? And then what? Combine the results(3 rows and then 2 rows) into a new sheet? This isn't possible with the data I am looking at, where there are hundreds of distinct IDs that are used by more then one row

  9. #9
    Forum Expert Carim's Avatar
    Join Date
    04-07-2006
    Posts
    4,070
    See attached ...
    Attached Files Attached Files

+ Reply to 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1