+ Reply to Thread
Results 1 to 1 of 1

Extract unique value in list and sort the result

  1. #1
    Forum Contributor
    Join Date
    04-23-2013
    Location
    Abu Dhabi United Arab Emirates
    MS-Off Ver
    Excel 2010
    Posts
    178

    Extract unique value in list and sort the result

    Hi,

    I want to extract the unique value in a list and sort:
    Column A Column B (RESULT)
    1 1
    7A 2
    1 2A
    3 2B
    2B 3
    2 4 on so on
    2A
    7
    2
    5
    4
    6
    6B
    6A

    Note: All data in Column A - numbers are started '1, '2, 3' and so on (force to text format)
    can anybody help me.
    Thanks in advance
    Last edited by acerrhod; 06-01-2013 at 05:52 AM.

+ Reply to Thread

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