+ Reply to Thread
Results 1 to 6 of 6

Excel - Dynamic Sorting? I think?

  1. #1
    Registered User
    Join Date
    06-01-2018
    Location
    Oklahoma City, Oklahoma
    MS-Off Ver
    MS Office 2016
    Posts
    8

    Question Excel - Dynamic Sorting? I think?

    DynamicSort.png


    Hello all,

    I'm attempting to reorganize the left table(which will eventually become hidden) into the right table to be sorted by rank(staring at 1, going to 20). Depending upon the position selected(E2:G3 DropDown List), the rank in the left table(column A under 'Rank')will change often, causing the order to change. I want the the office # and the corresponding count to transfer to the Table on the right accordingly but have ran into multiple issues when trying to INDEX the data. I would like to avoid clicking between each position selection and try to make this automatic.

    Any recommendations would be greatly appreciated!

  2. #2
    Banned User!
    Join Date
    02-05-2015
    Location
    San Escobar
    MS-Off Ver
    any on PC except 365
    Posts
    12,168

    Re: Excel - Dynamic Sorting? I think?

    Attach example EXCEL file (not a picture, pasted text or any other than Excel format!). This file should be attached to a new post. Never change your original post.

    In attached Excel file try not to use:
    • merged cells
    • password protection
    • unnecessary formatting like: colours, borders, aligning another than default, etc...
    • unnecessary zooming/grouping/freezeing
    You have words to logically describe the problem

    To attach an Excel file to your post,
    • desensitize data
    • remeber that your example should reflect structure and type of data and contain the result what you want to achieve (manually created if necessary)
    • click Go Advanced,
    • scroll down until you see Manage Attachments,
    • click that and select Browse,
    • select your file and click Open,
    • click Upload and you will see your attachment below Upload Files from a website
    • click Close this window,
    • click Submit reply

    After that you should see attachment in your post

  3. #3
    Registered User
    Join Date
    06-01-2018
    Location
    Oklahoma City, Oklahoma
    MS-Off Ver
    MS Office 2016
    Posts
    8

    Re: Excel - Dynamic Sorting? I think?

    I would think the above information would be enough to get a *recommendation* on how to do this.

  4. #4
    Banned User!
    Join Date
    02-05-2015
    Location
    San Escobar
    MS-Off Ver
    any on PC except 365
    Posts
    12,168

    Re: Excel - Dynamic Sorting? I think?

    recommendation? sure... load left table to PowerQuery editor, sort choosen column as you wish, load result query table into the sheet
    then it will be sorted automatically after every change in source table (result table refresh by ctrl+alt+F5)

  5. #5
    Registered User
    Join Date
    06-01-2018
    Location
    Oklahoma City, Oklahoma
    MS-Off Ver
    MS Office 2016
    Posts
    8

    Talking Re: Excel - Dynamic Sorting? I think?

    Worked perfect! thanks!!!

  6. #6
    Banned User!
    Join Date
    02-05-2015
    Location
    San Escobar
    MS-Off Ver
    any on PC except 365
    Posts
    12,168

    Re: Excel - Dynamic Sorting? I think?

    You are welcome

    If that takes care of your original question, & to say Thanks and for better Motivation, please
    1. click on Add Reputtion (bottom left corner of the post of the person(s) who helped you)
      then
    2. select Thread Tools from the menu (top right corner of your thread) and mark this thread as SOLVED.
    If you did it already - ignore it.
    Thank you.

    Have a nice day

    I'm impressed, first person who know what and where PowerQuery is

+ 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. One-time dynamic sorting for multiple Excel tabs.
    By jaljr in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 06-12-2017, 11:53 AM
  2. Dynamic Sorting
    By SCSM2650 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-19-2017, 12:01 AM
  3. Dynamic Sorting
    By pauldaddyadams in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-04-2013, 12:03 PM
  4. Dynamic table formula for sorting data to another table dynamic
    By 650dozer in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-21-2012, 07:22 PM
  5. Sorting text with dynamic excel sheet
    By ZackG in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-18-2011, 11:09 AM
  6. Dynamic sorting
    By מוטי in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 02-05-2006, 10:00 AM
  7. [SOLVED] Dynamic Sorting
    By Dr. Sachin Wagh in forum Excel General
    Replies: 2
    Last Post: 12-05-2005, 07:10 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