+ Reply to Thread
Results 1 to 7 of 7

Displaying the Lowest Text Classification

  1. #1
    Registered User
    Join Date
    04-05-2020
    Location
    America
    MS-Off Ver
    16
    Posts
    7

    Displaying the Lowest Text Classification

    Hey Team,

    I have a worksheet with different classifications on performance. For instance, one area may be "Fail", "Needs Improvement", Achieves", or "Excels".
    I want a cell to show the lowest classification. Its too easy to show if there is a failure, I can use an OR function to show if there is a failure. IF there is only Excels, then I can use the AND function.

    But suppose there are Two Excels, an Achieves, and one Needs Improvement, how can I get Excel to show the Needs Improvement?

    Thanks Team

    Respectfully

    -Phil

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel (Windows 11 64-bit)
    Posts
    62,194

    Re: Displaying the Lowest Text Classification

    Welcome to the forum.

    Instructions explaining how to provide a sample workbook are at the top of the page.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" to anyone who has offered you help in your thread. You can reward them by clicking on * Add Reputation below theur user name on the left, if you wish.


    Forum Rules (updated September 2018): please read them here.
    How to use the Power Query code you've been given: help here. More about the Power suite here.

  3. #3
    Registered User
    Join Date
    04-05-2020
    Location
    America
    MS-Off Ver
    16
    Posts
    7

    Re: Displaying the Lowest Text Classification

    This is a worksheet I created to go with my question. Im not using the actual one to protect personal information, but the concept is the same.
    Please let me know if you have any thoughts.

    Thanks.

    -Phil
    Attached Files Attached Files

  4. #4
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel (Windows 11 64-bit)
    Posts
    62,194

    Re: Displaying the Lowest Text Classification

    Will there be the empty rows in the real data? It's easy if not.

    Excel 2016 (Windows) 32 bit
    A
    B
    C
    D
    E
    1
    Category
    Standard Achieved
    2
    Character
    Excels
    Ranking of Standards
    3
    Presence
    Excels
    Excels
    4
    4
    Intellect
    Achieves
    Achieves
    3
    5
    Leads
    Excels
    Needs Improvement
    2
    6
    Develops
    Needs Improvement
    Fail
    1
    7
    Production
    Achieves
    8
    9
    Overall Standard Achieved
    10
    Needs Improvement
    11
    Sheet: Sheet1

    Excel 2016 (Windows) 32 bit
    B
    10
    =INDEX($D$3:$D$6,MATCH(MIN(INDEX($E$3:$E$6,N(IF(1,MATCH(B$2:B$7,$D$3:$D$6,0))))),$E$3:$E$6,0))
    Sheet: Sheet1

    ... confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer.
    Last edited by AliGW; 04-05-2020 at 05:03 AM.

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

    Re: Displaying the Lowest Text Classification

    Please try
    =INDEX($D$3:$D$6,AGGREGATE(14,6,MATCH(B2:B12,$D$3:$D$6,),1))

  6. #6
    Registered User
    Join Date
    04-05-2020
    Location
    America
    MS-Off Ver
    16
    Posts
    7

    Re: Displaying the Lowest Text Classification

    Thanks Team,

    This worked perfectly.
    Youre the best

    v\r

    -Phil

  7. #7
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel (Windows 11 64-bit)
    Posts
    62,194

    Re: Displaying the Lowest Text Classification

    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

+ 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. Excel displaying wrong number in lowest net score
    By Lc1846 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 05-26-2019, 02:29 PM
  2. Displaying the lowest value for the next x days of data
    By stubbers in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-19-2017, 06:46 PM
  3. Need help displaying result of lowest number
    By TexasAggie13 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-09-2016, 05:09 PM
  4. Displaying the difference of the lowest in a range
    By bobbby1949 in forum Excel General
    Replies: 8
    Last Post: 03-17-2011, 11:19 PM
  5. Displaying true or false if a cell is the lowest value
    By jasonmatthaynes in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 11-19-2008, 11:11 PM
  6. [SOLVED] Formula for displaying in 1 cell Lowest value from multiple other cells
    By Doug_montgomery@Captainds.com in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-16-2006, 07:10 PM
  7. Formula for displaying the lowest number of a range?
    By coal_miner in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-25-2005, 10:06 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1