Results 1 to 4 of 4

Unique distinct alphabetically sorted list

Threaded View

atlant15 Unique distinct... 02-06-2013, 09:12 AM
benishiryo Re: Unique distinct... 02-06-2013, 09:20 AM
atlant15 Re: Unique distinct... 02-06-2013, 09:55 AM
atlant15 Re: Unique distinct... 02-06-2013, 10:03 AM
  1. #1
    Registered User
    Join Date
    02-06-2011
    Location
    Tel aviv, Israel
    MS-Off Ver
    Excel 2013
    Posts
    59

    Unique distinct alphabetically sorted list

    Hello,

    I have a list I wish to sort by alphabetic order.
    I also have two criteria though;

    Attached is an example file...

    I have a list of countries in column A, and a list of sites in column B.
    I already made a unique list of countries (column D, in the example) out of the list in column A, and this list is a bridge-step so I can have the countries names as headlines (Row 1, column F-J) – if anyone can offer me a formula to have it directly to the headline spots (without using column D, that will be great as well) – as you can see I left additional 2 spots as headlines (in blue) for future update.

    In the yellow section I want to have the unique list of sites per country (alphabetically order), I managed to build a formula that returns every site within the specific country but with duplicated values (with Index formula), I can't find a way to have it as a unique list).

    Your assistance is much appreciate.

    Thanks.
    Attached Files Attached Files

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