Assume the 4 different cells are A23:A26 and the result in A27. The formula in A27 is =INDEX( {"A","A-","A-","B","B","C","C","C","C","C","C","C","C","C","C"}, 1, MATCH( COUNTIF(A23:A26,"Green")+ COUNTIF(A23:A26,"Orange")*10+ COUNTIF(A23:A26,"Red...
This approach is not good. I think there should be a better approach from other helpers. Thanks for the reply Willy🙂 Ok I’ll try an make it a bit clearer so I have the following cells with drop down tabs A23 (with drop down tabs - Green, orange,red, pending) A25 - Green, ora...
At the bottom Manage resource accounts in teams, there is a section for deleting resource accounts. Manage resource accounts in Teams - Microsoft Teams | Microsoft Docs It states: Make sure you... If you delete a resource account without first removing the phone number you c...