Results 1 to 10 of 10

Return the list of marked cells

Threaded View

  1. #1
    Registered User
    Join Date
    11-07-2012
    Location
    Poland
    MS-Off Ver
    Excel 2010
    Posts
    21

    Unhappy Return the list of marked cells

    Hi!

    Please help me with the following problem:

    I have a range of cells that are marked by me, such as

    A ; Football
    A ; Football
    A ; Basketball
    A ; Tennis
    B ; Swimming
    B ; Swimming
    B ; Running
    A ; Climbing
    A ; Tennis
    B ; Baking
    B ; Swimming

    What i want is to have a list of A's and B's, such as:

    Football
    Football
    Basketball
    Tennis
    Tennis
    Climbing
    Tennis

    and a second list

    Swimming
    Swimming
    Running
    Baking
    Swimming

    Can't handle that, tried indexing and such things, but I'm not an excel pro so any help would be appreciated
    Last edited by kissmydrone; 11-07-2012 at 07:59 AM.

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