+ Reply to Thread
Results 1 to 3 of 3

Formula help for to make a Sort, Unique list

  1. #1
    Registered User
    Join Date
    08-19-2020
    Location
    Dubai
    MS-Off Ver
    Office365
    Posts
    85

    Formula help for to make a Sort, Unique list

    Hi,


    I required a formula help for to make a unique list, here i have used a formula.

    =SORT(UNIQUE(FILTERXML("<a><b>"&TEXTJOIN("</b><b>",1,'GRP & GRE Pipe Fittings - Gulf '!F8:F702)&"</b></a>","//b"))) but is it returns as #VALUE!


    Could you please someone help to get solution.


    Thanks,

  2. #2
    Forum Guru Bo_Ry's Avatar
    Join Date
    09-10-2018
    Location
    Thailand
    MS-Off Ver
    MS 365
    Posts
    5,845

    Re: Formula help for to make a Sort, Unique list

    Try this

    =SORT(UNIQUE('GRP & GRE Pipe Fittings - Gulf '!F8:F702))

    If not work, Please provide sample file.

  3. #3
    Registered User
    Join Date
    08-19-2020
    Location
    Dubai
    MS-Off Ver
    Office365
    Posts
    85

    Re: Formula help for to make a Sort, Unique list

    Quote Originally Posted by Bo_Ry View Post
    Try this

    =SORT(UNIQUE('GRP & GRE Pipe Fittings - Gulf '!F8:F702))

    If not work, Please provide sample file.
    Thanks Bo_Ry its for your solution its working perfectly.


    Thanks,

+ 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: 7
    Last Post: 11-21-2016, 04:40 PM
  2. Data Validation List - Formula to Sort and Return Unique Values in List
    By beewketu in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-14-2015, 04:18 PM
  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. Replies: 1
    Last Post: 04-19-2013, 02:25 AM
  5. Make list of unique values
    By Roeltje in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 10-12-2011, 09:03 AM
  6. Replies: 7
    Last Post: 07-24-2010, 08:07 PM
  7. Match, Sort unique list
    By Mut in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-23-2006, 04:36 AM

Tags for this Thread

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