+ Reply to Thread
Results 1 to 5 of 5

Want unique value only but with alphabetically

  1. 02-19-2017, 01:19 AM #1
    HaroonSid
    HaroonSid is offline
    Forum Contributor HaroonSid's Avatar
    Join Date
    02-28-2014
    Location
    india
    MS-Off Ver
    Excel 2013
    Posts
    2,080

    Want unique value only but with alphabetically

    hello, everone

    i am using below formula to get unique names, But i want those value in alphabetically order
    Please Login or Register  to view this content.
    Please Login or Register  to view this content.
    Capture.JPG

    Capture2.JPG


    thanx
    Attached Files Attached Files
    Use Code-Tags for showing your code :
    Please mark your question Solved if there has been offered a solution that works fine for you
    If You like solutions provided by anyone, feel free to add reputation using STAR *
    Reply With QuoteRegister To Reply
  2. 02-19-2017, 01:31 AM #2
    MarvinP
    MarvinP is offline
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    16,168

    Re: Want unique value only but with alphabetically

    Hi Haroon,

    If you do a simple Pivot Table and use the Names as the Rows it will give you what you want. See the attached.

    PT to Alpha Unique Names.xlsm
    One test is worth a thousand opinions.
    Click the * Add Reputation below to say thanks.
    Reply With QuoteRegister To Reply
  3. 02-19-2017, 01:42 AM #3
    JieJenn
    JieJenn is offline
    Forum Expert
    Join Date
    12-15-2009
    Location
    Chicago, IL
    MS-Off Ver
    Microsoft Office 365
    Posts
    3,177

    Re: Want unique value only but with alphabetically

    Probably more convenient than formula if you use VBA

    Please Login or Register  to view this content.
    Learn Data Analysis or Excel youtube.com/jiejenn
    Reply With QuoteRegister To Reply
  4. 02-19-2017, 01:53 AM #4
    HaroonSid
    HaroonSid is offline
    Forum Contributor HaroonSid's Avatar
    Join Date
    02-28-2014
    Location
    india
    MS-Off Ver
    Excel 2013
    Posts
    2,080

    Re: Want unique value only but with alphabetically

    Thanx for the reply
    @jiejenn

    i have formulas in B10:B2000
    Reply With QuoteRegister To Reply
  5. 02-19-2017, 02:12 AM #5
    JieJenn
    JieJenn is offline
    Forum Expert
    Join Date
    12-15-2009
    Location
    Chicago, IL
    MS-Off Ver
    Microsoft Office 365
    Posts
    3,177

    Re: Want unique value only but with alphabetically

    Paste as just text first. 

    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Formula to get unique and alphabetically sorted list after matching a criteria
    By Saranya A in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 10-20-2016, 06:50 AM
  2. [SOLVED] How to deal with blank cells to get unique distinct alphabetically sorted list?
    By keyantkarthi in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 12-28-2015, 09:13 AM
  3. [SOLVED] Dynamic Formula for Getting Unique Items from a list and sort them alphabetically
    By tuckertheguy in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 09-18-2015, 03:57 AM
  4. [SOLVED] Summerize unique values from multiple columns / Sorted alphabetically
    By Lacaycer in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 12-01-2014, 02:40 PM
  5. [SOLVED] Formula to extract unique values from two excel tabs and sort alphabetically
    By rshukla in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-06-2013, 01:48 PM
  6. sorting unique cells alphabetically using array
    By freegame in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-01-2013, 12:16 AM
  7. [SOLVED] Unique distinct alphabetically sorted list
    By atlant15 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-06-2013, 10:03 AM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1