Results 1 to 6 of 6

List of names appearing multiple times but with different adjacent value

Threaded View

ron2k_1 List of names appearing... 02-03-2011, 07:53 PM
MarvinP Re: List of names appearing... 02-03-2011, 08:40 PM
ron2k_1 Re: List of names appearing... 02-03-2011, 09:04 PM
ron2k_1 Re: List of names appearing... 02-03-2011, 09:42 PM
MarvinP Re: List of names appearing... 02-03-2011, 09:53 PM
ron2k_1 Re: List of names appearing... 02-04-2011, 01:27 AM
  1. #1
    Valued Forum Contributor ron2k_1's Avatar
    Join Date
    09-30-2009
    Location
    Not the USA
    MS-Off Ver
    Excel 2003, 2007
    Posts
    606

    List of names appearing multiple times but with different adjacent value

    Hey good gentlemen and gentleladies of the forum,

    Kindly look at the attached. I have explained my dilema there. But basically the scenario is this:
    1. 1 table with two columns and 2000 rows
    2. Names on Column A appear multiple times
    3. Corresponding value on column B is for items they consumed. This is generally the same for all values in column A
    4. However, every now and again they will consume something else.

    And what I need is a list on a different sheet within the same workbook of all those people that appeared multiple times BUT only those that consumed more than 1 item. See attached to see the columns that I need on the filtered list. I know autofilter can do it, but then I'll have to go one by one to see those that consumed different product.

    thanks,
    Attached Files Attached Files
    Last edited by ron2k_1; 02-03-2011 at 09:44 PM.
    Ron
    Knowledge is knowing that a tomato and pepper are fruits. Wisdom is knowing whether to put these in a fruit salad

    Kindly

    [1] Use code tags. Place "[code]" before the first line of code and "[/code"]" after the last line of code. Exclude quotation marks
    [2] Mark your post [SOLVED] if it has been answered satisfactorily by editing your original post in advanced mode.
    [3] Thank (using the little scale) those that provided useful help; its nice and its very well appreciated

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