+ Reply to Thread
Results 1 to 2 of 2

Formula to sort by largest % to lowest while dynamically changing the attribute names

  1. #1
    Registered User
    Join Date
    06-17-2020
    Location
    Canada
    MS-Off Ver
    2019
    Posts
    27

    Formula to sort by largest % to lowest while dynamically changing the attribute names

    Looking for a dynamic formula that will automatically sort each column from largest to smallest while dynamically also changing the attribute

    I know i can filter for each person, but that becomes time consuming when the list of names is longer.

    So for example, i'm looking for a formula that will sort attributes associated with Kylie from largest to small. The order should look like:
    - Untrustworthy Credible
    - Unreltable Relatable
    - Fake Realistic
    - Dull Attention
    - Uninspiring Inspiring... etc

    But for Sam, the order would change to :
    - Fake Realistic
    - Unrelatable Relatable
    - Untrustworthy Credible... etc


    hoping that the formula, will also update the attribute per person.
    Attached Files Attached Files

  2. #2
    Forum Contributor
    Join Date
    08-12-2020
    Location
    Atlanta, Georgia
    MS-Off Ver
    Office 16
    Posts
    241

    Re: Formula to sort by largest % to lowest while dynamically changing the attribute names

    Your attachment is corrupted. Please re-attach without the symbols.

+ 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: 5
    Last Post: 10-25-2016, 11:48 AM
  2. Replies: 1
    Last Post: 04-16-2015, 06:29 PM
  3. Replies: 1
    Last Post: 03-04-2015, 02:57 PM
  4. How Sort by Largest to Smallest Column by Formula
    By termal in forum Excel General
    Replies: 10
    Last Post: 01-08-2014, 01:17 PM
  5. Replies: 3
    Last Post: 11-28-2013, 02:11 AM
  6. Sort by largest number in column by Formula Function
    By termal in forum Excel General
    Replies: 5
    Last Post: 05-04-2009, 07:46 PM
  7. Replies: 5
    Last Post: 06-05-2006, 08:30 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