Check if Teams pick a name as representative & agree on a name

AliGW, in Polish, I would be able to explain everything down to the last detail as best I can. Unfortunately, due to language problems, I don't always have the courage to explain something in English. I use Google Translator all the time, which doesn't always translate my thoughts as expected. Besides, I don't know what level of knowledge the OP is. When he has more, a detailed description seems unnecessary - he only needs to show the direction. In addition, self-investigation to a solution gives more satisfaction and causes that the acquired knowledge stays with us for longer. If the OP has a problem with something, he can always ask a question. Me or someone else will explain it to him then.

Artik

Here are the details for the benefit of anyone unable to access the attachment (added by AliGW):

In K6: =IF(COUNTA(Table24[@])=4,COUNTIF(Table24[@],$K$3),"") - K3 contains the letter (name) required - Artik added a drop-down selection list for this)

CF Rules:

Red =AND(ISNUMBER($K6),$K6<2)
Amber =AND(ISNUMBER($K6),$K6=2)
Green =AND(ISNUMBER($K6),$K6>=3)

Alternatively:

AliGW on MS365 Insider (Windows) 32 bit

	K	L	M	N
20	A	B	C	D
21	4	0	0	0
22	3	0	1	0
23	2	1	0	1
24	1	1	1	1

Sheet: Sheet2

AliGW on MS365 Insider (Windows) 32 bit

	K
21	=IF(COUNTA(Table242[@])=4,COUNTIF(Table242[@],K$20),"")

Sheet: Sheet2