Results 1 to 5 of 5

Preventing duplicate entries and sorting by alphabetical using Index feature

Threaded View

  1. #1
    Registered User
    Join Date
    01-10-2010
    Location
    Glasgow
    MS-Off Ver
    Excel 2003
    Posts
    9

    Preventing duplicate entries and sorting by alphabetical using Index feature

    Hey guys,

    This is I hope a very simple request and although I've looked online for a solution, I haven't yet found one which fits both criteria at the same time and I'm absolutely hopeless at formulas so hoping someone can have a quick look and help me out.

    I've got a very basic spreadsheet with a list of names. On a second sheet I've used the =INDEX function to replicate it but only choosing 4 random names out of the 20 available. What I need to do is:

    (a) Prevent duplicate entries from appearing.

    (b) Sort the generated list in alphabetical order.

    Simple but only if you know how I guess. And I haven't got a clue how to do it.

    Thanks in advance for anyone who can help.
    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