+ Reply to Thread
Results 1 to 2 of 2

Sorting a list with Index/Match imported words

  1. #1
    Registered User
    Join Date
    06-22-2015
    Location
    London, England
    MS-Off Ver
    2013
    Posts
    1

    Sorting a list with Index/Match imported words

    Dear all,

    I have a list with words imported by the Index/Match function that I need to alphabetically sort. Using the sort function tool bluntly does not seem to work. I can't remove the formulas since the list needs to remain flexible - is there any way how I can alphabetically sort it anyhow?

    Thank you for your help!

  2. #2
    Valued Forum Contributor mahju's Avatar
    Join Date
    11-27-2010
    Location
    Pakistan, Faisalabad
    MS-Off Ver
    Excel 2010 plus
    Posts
    730

    Re: Sorting a list with Index/Match imported words

    Use copy - paste special - values to another sheet and sort that list.

    You can create a macro to do it automatically when needed

    Regards
    Mark the thread as solved if you are satisfied with the answer.


    In your first post under the thread tools.

    Mahju

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 6
    Last Post: 11-08-2013, 10:29 PM
  2. Match/Index/Sorting
    By Lena111 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 07-17-2013, 02:12 PM
  3. [SOLVED] Using Index Match or Vlookup giving unexpected results on imported data
    By jacob@thepenpoint in forum Excel General
    Replies: 2
    Last Post: 07-03-2012, 05:49 PM
  4. Replies: 1
    Last Post: 04-04-2012, 07:15 PM
  5. Match imported data to list
    By E2T in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-24-2008, 02:00 PM

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