counting multiple occurences in a row

[Flashboy]

hey guys

I am trying to count multiple occurences in a table. what I'm trying to do is only count when a team has 2 or more the same, so in this instance as copper and iron are top i want a formula to return Yes as i can see at a glance the team have hit top in more than one area.

See example below

Thanks

main team	Team	Copper	Copper Tasks	Iron	Iron Tasks	Steel	Steel Tasks	Alloy	Alloy Tasks
ABC11	ABC111	Top	11	Top	28	Very Bottom	8	0	0

<colgroup><col style="width: 52pt; mso-width-source: userset; mso-width-alt: 2523;" width="69"> <col style="width: 50pt; mso-width-source: userset; mso-width-alt: 2450;" width="67"> <col style="width: 64pt; mso-width-source: userset; mso-width-alt: 3108;" width="85"> <col style="width: 90pt; mso-width-source: userset; mso-width-alt: 4388;" width="120"> <col style="width: 64pt; mso-width-source: userset; mso-width-alt: 3108;" width="85"> <col style="width: 74pt; mso-width-source: userset; mso-width-alt: 3584;" width="98"> <col style="width: 64pt; mso-width-source: userset; mso-width-alt: 3108;" width="85"> <col style="width: 71pt; mso-width-source: userset; mso-width-alt: 3474;" width="95"> <col style="width: 64pt; mso-width-source: userset; mso-width-alt: 3108;" width="85"> <col style="width: 68pt; mso-width-source: userset; mso-width-alt: 3328;" width="91"> <tbody>
</tbody>

 

[jim may]

Not sure, but do you mean..

Excel 2012
	A	B	C	D	E	F	G	H	I	J
1	main team	Team	Copper	Copper Tasks	Iron	Iron Tasks	Steel	Steel Tasks	Alloy	Alloy Tasks
2	ABC11	Yes	Top	11	Top	28	Very Bottom	8	0	0
Sheet3

Cell Formulas
Range	Formula
B2	=IF(COUNTIF(C2:I2,"Top")>=2,"Yes","")

 

[Flashboy]

I was going to put it in a new column but the formula works a treat!

Thanks

Flash

hey guys

I am trying to count multiple occurences in a table. what I'm trying to do is only count when a team has 2 or more the same, so in this instance as copper and iron are top i want a formula to return Yes as i can see at a glance the team have hit top in more than one area.

See example below

Thanks

main team	Team	Copper	Copper Tasks	Iron	Iron Tasks	Steel	Steel Tasks	Alloy	Alloy Tasks
ABC11	ABC111	Top	11	Top	28	Very Bottom	8	0	0

<tbody>
</tbody>

 

[Flashboy]

So if i wanted to use a formula like this to count if 2 criteria was met such as top and very bottom how would i do that?

Sorry about this but its all helping me learn