+ Reply to Thread
Results 1 to 15 of 15

Formula to show results of evaluation tie match

  1. 08-23-2022, 05:41 PM #1
    douggie
    douggie is offline
    Registered User
    Join Date
    09-22-2009
    Location
    Sydney,Australia
    MS-Off Ver
    MS Office 365
    Posts
    39

    Formula to show results of evaluation tie match

    Hi,

    I am seeking help in a formula to show the results from evaluation that either shows if the consensus is either Exceptional, Satisfactory, Unsatisfactory base on the evaluation selection from other people.

    Column "O" should show the consensus of "K-N" but I cant seem to figure it out.

    I have attached a sample with drop list selection for "K-N"

    This has also been posted in another thread/ forum that was for a pass/fail formula that was resolved.


    https://www.excelforum.com/excel-for...-with-tie.html



    Thanks in advance
    Attached Files Attached Files
    Last edited by douggie; 08-28-2022 at 06:50 PM.
    Reply With QuoteRegister To Reply
  2. 08-25-2022, 08:37 AM #2
    AliGW
    AliGW is offline
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (both in England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2503 (Windows 11 Home 24H2 64-bit)
    Posts
    90,278

    Re: Formula to show results of evaluation tie match

    Administrative Note:

    We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not told us about this. You are required to do so.

    Please see Forum Rule #3 about cross-posting and adjust accordingly. Read this to understand why we (and other sites like us) consider this to be important.

    (Note: this requirement is not optional. No help to be offered until you provide a link or, for members with fewer than 10 posts, a comment telling us where else you have posted this query.)
    Ali

    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
    NB:     as a Moderator, I never accept friendship requests.
    Forum Rules (updated August 2023): please read them here.
    Reply With QuoteRegister To Reply
  3. 08-28-2022, 06:48 PM #3
    douggie
    douggie is offline
    Registered User
    Join Date
    09-22-2009
    Location
    Sydney,Australia
    MS-Off Ver
    MS Office 365
    Posts
    39

    Re: Formula to show results of evaluation tie match

    Hi Thanks,

    I am still relevantly new to all of this even thou I have been a member since 2009, I rarely come on here only when I am stuck. What takes me a few hours or days to day the Gurus on here can do it in a matter on minutes. Rules are rules and such as I must adhere to them so as not to cause any confusion amongst the posts.

    Sorry for this.
    Reply With QuoteRegister To Reply
  4. 08-29-2022, 12:55 AM #4
    AliGW
    AliGW is offline
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (both in England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2503 (Windows 11 Home 24H2 64-bit)
    Posts
    90,278

    Re: Formula to show results of evaluation tie match

    You are required to provide links to other forums where you gave posted THIS question, not to other questions you have asked here.

    No help can be given until you do this.
    Reply With QuoteRegister To Reply
  5. 08-30-2022, 10:55 PM #5
    douggie
    douggie is offline
    Registered User
    Join Date
    09-22-2009
    Location
    Sydney,Australia
    MS-Off Ver
    MS Office 365
    Posts
    39

    Re: Formula to show results of evaluation tie match

    Okay.

    You mean like
    https://www.mrexcel.com/board/thread.../#post-5937963
    Reply With QuoteRegister To Reply
  6. 08-31-2022, 01:04 AM #6
    AliGW
    AliGW is offline
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (both in England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2503 (Windows 11 Home 24H2 64-bit)
    Posts
    90,278

    Re: Formula to show results of evaluation tie match

    Yes - thanks.
    Reply With QuoteRegister To Reply
  7. 08-31-2022, 03:15 AM #7
    Glenn Kennedy
    Glenn Kennedy is offline
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2406
    Posts
    44,662

    Re: Formula to show results of evaluation tie match

    There are formulae in column O. They give results.

    Are they the correct results? If so... what do you need?

    If not, what ARE the expected results? How would you calculate them manually?
    Glenn



    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU
    Reply With QuoteRegister To Reply
  8. 08-31-2022, 07:43 PM #8
    douggie
    douggie is offline
    Registered User
    Join Date
    09-22-2009
    Location
    Sydney,Australia
    MS-Off Ver
    MS Office 365
    Posts
    39

    Re: Formula to show results of evaluation tie match

    Hi Glenn,

    I have uploaded a new sample workbook with comments for results of "O".

    If I was to calculate manually, it would be the general agreement of the assessment of "Exceptional/ Satisfactory/ Unsatisfactory".e.g. if 2 of the 3 have assessed as Satisfactory and 1 has
    assessed unsatisfactory then the general agreement would be Satisfactory. If 2 have assessed as Satisfactory and 2 have assessed as Unsatisfactory then the general agreement will be a tie result.

    Thanks
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  9. 08-31-2022, 09:03 PM #9
    Gregb11
    Gregb11 is offline
    Forum Expert
    Join Date
    02-10-2019
    Location
    Georgia, USA
    MS-Off Ver
    Office 365
    Posts
    3,174

    Re: Formula to show results of evaluation tie match

    You show an example of 4 being "Satisfactory" and your consensus says it should be "Exceptional". Why isn't it "Satisfactory?
    If 2 are "Unsatisfactory", and 1 is Excellent and 1 is Satisfactory, should the consensus by "Unsatisfactory?
    What if 1 is "Unsatisfactory", 1 is "Satisfactory", and 1 is "Excellent" - what's the consensus, "Satisfactory", "Tie", or "Blank"?
    Reply With QuoteRegister To Reply
  10. 09-01-2022, 01:13 AM #10
    douggie
    douggie is offline
    Registered User
    Join Date
    09-22-2009
    Location
    Sydney,Australia
    MS-Off Ver
    MS Office 365
    Posts
    39

    Re: Formula to show results of evaluation tie match

    Hi Gregb11,

    You show an example of 4 being "Satisfactory" and your consensus says it should be "Exceptional". Why isn't it "Satisfactory?
    Sorry this is a error on my side as I probably didn't realize that the cell changed. Yes you are correct the result should be satisfactory.

    If 2 are "Unsatisfactory", and 1 is Excellent and 1 is Satisfactory, should the consensus by "Unsatisfactory?
    Yes that is correct

    What if 1 is "Unsatisfactory", 1 is "Satisfactory", and 1 is "Excellent" - what's the consensus, "Satisfactory", "Tie", or "Blank"?
    The result should be a tie.

    A blank or empty cell should only be there if no selection for "K,L,M,N".
    Reply With QuoteRegister To Reply
  11. 09-01-2022, 01:16 AM #11
    douggie
    douggie is offline
    Registered User
    Join Date
    09-22-2009
    Location
    Sydney,Australia
    MS-Off Ver
    MS Office 365
    Posts
    39

    Re: Formula to show results of evaluation tie match

    Please see image
    Attached Images Attached Images
    Last edited by douggie; 09-01-2022 at 01:17 AM. Reason: Image attached
    Reply With QuoteRegister To Reply
  12. 09-01-2022, 01:17 AM #12
    AliGW
    AliGW is offline
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (both in England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2503 (Windows 11 Home 24H2 64-bit)
    Posts
    90,278

    Re: Formula to show results of evaluation tie match

    Please provide a workbook showing the issue, not a picture.
    Reply With QuoteRegister To Reply
  13. 09-01-2022, 06:57 AM #13
    Gregb11
    Gregb11 is offline
    Forum Expert
    Join Date
    02-10-2019
    Location
    Georgia, USA
    MS-Off Ver
    Office 365
    Posts
    3,174

    Re: Formula to show results of evaluation tie match

    Maybe someone else can come up with a succinct formula, but I kind of piece-mealed this one together and it seems to work. Maybe if I get more time later tonight I'll take another look to see how it can be improved. Anyway, in cell O12 try this (and copy down):

    =IF(COUNTIFS(K12:N12,"Please select from list")=4,"",LET(a,CHOOSE({1,2,3},COUNTIFS(K12:N12,"UNSATISFACTORY"),COUNTIFS(K12:N12,"SATISFACTORY"),COUNTIFS(K12:N12,"EXCEPTIONAL")),
    IF(COUNT(FILTER(a,a=MAX(a)))>=2,"Tie",CHOOSE(MATCH(MAX(a),a,0),"Unsatisfactory","Satisfactory","Exceptional"))))
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  14. 09-04-2022, 07:07 PM #14
    douggie
    douggie is offline
    Registered User
    Join Date
    09-22-2009
    Location
    Sydney,Australia
    MS-Off Ver
    MS Office 365
    Posts
    39

    Re: Formula to show results of evaluation tie match

    Hi Gregb11,

    It works, thanks very much for your help, time and expertise in solving the matter, much appreciated. :-)
    Reply With QuoteRegister To Reply
  15. 09-04-2022, 08:59 PM #15
    Gregb11
    Gregb11 is offline
    Forum Expert
    Join Date
    02-10-2019
    Location
    Georgia, USA
    MS-Off Ver
    Office 365
    Posts
    3,174

    Re: Formula to show results of evaluation tie match

    You're welcome. Thanks for the feedback and rep!
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Having a risk evaluation automatically fill out based on results of two drop down options
    By jhanns in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 12-22-2020, 07:53 AM
  2. [SOLVED] IF Formula to show only last 6 results
    By BlindAlley in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-23-2016, 10:06 AM
  3. Formula results to show as 0 if <0 or >40,000
    By bec_microsoft in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 01-18-2016, 12:01 AM
  4. [SOLVED] Show days of current month in evaluation drop down
    By juriemagic in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-19-2014, 09:57 AM
  5. [SOLVED] Using VLookup but results show formula instead of results...
    By excel me in forum Excel Formulas & Functions
    Replies: 19
    Last Post: 11-28-2013, 09:40 PM
  6. Show results in formula bar
    By desktop in forum Excel General
    Replies: 1
    Last Post: 10-04-2012, 02:04 AM
  7. Only show formula results if not 0 (zero)
    By randolphoralph in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-29-2008, 12:42 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1