+ Reply to Thread
Results 1 to 3 of 3

Sort alphabetically a formula result

  1. #1
    Registered User
    Join Date
    06-14-2020
    Location
    Indonesia
    MS-Off Ver
    Office 2019
    Posts
    1

    Sort alphabetically a formula result

    I am making a list of product order and it's amounts from a list of the purchase order. I managed to extract the product name and its amounts using
    Please Login or Register  to view this content.
    but, i can't sort the product name result with "sort" from "Data" menu.
    here is the sample:
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Excel 2016
    Posts
    13,764

    Re: Sort alphabetically a formula result

    @KyonDW

    Welcome to this excel forum.

    Select C2:E8 (bleu cells).

    data => sort => sort on colum c

    After that you get the result in the green cells.

    See the attached file.
    Notice my main language is not English.

    I appreciate it, if you reply on my solution.

    If you are satisfied with the solution, please mark the question solved.

    You can add reputation by clicking on the star * add reputation.

  3. #3
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs
    MS-Off Ver
    MS Office 2019; O365
    Posts
    19,176

    Re: Sort alphabetically a formula result

    Using Power Query/Get & Transform (found on the Data Tab), here is the Mcode, the result and your workbook for analyis.

    Please Login or Register  to view this content.
    Excel 2016 (Windows) 32 bit
    A
    B
    1
    Product Name Amount of Product
    2
    Ayam /kg
    4
    3
    Babat /kg
    2
    4
    Beras lumbung desa
    1
    5
    Bimoli 5L
    2
    6
    Daging sapi /kg
    6
    7
    Emping biasa /kg
    3
    8
    Emping matang manis /kg
    1
    9
    Paket Anak 3
    1
    10
    Paket buah
    1
    11
    Suuk putih /bungkus
    2
    12
    sasa 100gr
    2
    Sheet: Sheet2
    Review PQ
    In the attached file
    Click on any cell in the new table
    On the Data Tab, click on Queries & Connections
    In the right window, double click to open Query
    Review PQ steps

    M-code basics:
    - "let" is the start of a query
    - "in" is the closing of a query
    - each transformation step sits in between those 2 lines
    - each step line is ended by a comma, except the last one
    - "Source" is always the first step (Source Data)
    - After "in" you have the last step referenced
    Attached Files Attached Files

+ 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. Non Array Formula to Sort Values Alphabetically
    By bjnockle in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-28-2018, 06:21 PM
  2. [SOLVED] Change Formula to VBA Sort List alphabetically with 2 criteria
    By annazet in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 03-19-2018, 10:21 AM
  3. Replies: 9
    Last Post: 01-18-2018, 03:00 AM
  4. [SOLVED] VBA or normal formula to Auto-sort alphabetically.
    By Anarchus in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-24-2016, 06:53 PM
  5. [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
  6. [SOLVED] Using an array formula to sort alphabetically over multiple columns
    By AliGW in forum Excel Formulas & Functions
    Replies: 18
    Last Post: 02-14-2014, 02:13 PM
  7. Sort text list alphabetically using a formula
    By paddyyates in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 12-20-2005, 11:15 PM

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