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

[TABLE="width: 661"]
<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>[TR]
[TD="class: xl66, width: 69, bgcolor: #8064A2"]main team[/TD]
[TD="class: xl66, width: 67, bgcolor: #8064A2"]Team[/TD]
[TD="class: xl66, width: 85, bgcolor: #8064A2"]Copper[/TD]
[TD="class: xl66, width: 120, bgcolor: #8064A2"]Copper Tasks[/TD]
[TD="class: xl66, width: 85, bgcolor: #8064A2"]Iron[/TD]
[TD="class: xl66, width: 98, bgcolor: #8064A2"]Iron Tasks[/TD]
[TD="class: xl66, width: 85, bgcolor: #8064A2"]Steel[/TD]
[TD="class: xl66, width: 95, bgcolor: #8064A2"]Steel Tasks[/TD]
[TD="class: xl66, width: 85, bgcolor: #8064A2"]Alloy[/TD]
[TD="class: xl66, width: 91, bgcolor: #8064A2"]Alloy Tasks[/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: #D9D9D9"]ABC11[/TD]
[TD="class: xl67, bgcolor: #D9D9D9"]ABC111[/TD]
[TD="class: xl67"]Top [/TD]
[TD="class: xl67, bgcolor: #D9D9D9"]11[/TD]
[TD="class: xl67"]Top[/TD]
[TD="class: xl67, bgcolor: #D9D9D9"]28[/TD]
[TD="class: xl67"]Very Bottom[/TD]
[TD="class: xl67, bgcolor: #D9D9D9"]8[/TD]
[TD="class: xl67, bgcolor: #D9D9D9"]0[/TD]
[TD="class: xl67, bgcolor: #D9D9D9"]0[/TD]
[/TR]
</tbody>[/TABLE]

 

[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

[TABLE="width: 661"]
<tbody>[TR]
[TD="class: xl66, width: 69, bgcolor: #8064A2"]main team
[/TD]
[TD="class: xl66, width: 67, bgcolor: #8064A2"]Team
[/TD]
[TD="class: xl66, width: 85, bgcolor: #8064A2"]Copper
[/TD]
[TD="class: xl66, width: 120, bgcolor: #8064A2"]Copper Tasks
[/TD]
[TD="class: xl66, width: 85, bgcolor: #8064A2"]Iron
[/TD]
[TD="class: xl66, width: 98, bgcolor: #8064A2"]Iron Tasks
[/TD]
[TD="class: xl66, width: 85, bgcolor: #8064A2"]Steel
[/TD]
[TD="class: xl66, width: 95, bgcolor: #8064A2"]Steel Tasks
[/TD]
[TD="class: xl66, width: 85, bgcolor: #8064A2"]Alloy
[/TD]
[TD="class: xl66, width: 91, bgcolor: #8064A2"]Alloy Tasks
[/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: #D9D9D9"]ABC11
[/TD]
[TD="class: xl67, bgcolor: #D9D9D9"]ABC111
[/TD]
[TD="class: xl67"]Top
[/TD]
[TD="class: xl67, bgcolor: #D9D9D9"]11
[/TD]
[TD="class: xl67"]Top
[/TD]
[TD="class: xl67, bgcolor: #D9D9D9"]28
[/TD]
[TD="class: xl67"]Very Bottom
[/TD]
[TD="class: xl67, bgcolor: #D9D9D9"]8
[/TD]
[TD="class: xl67, bgcolor: #D9D9D9"]0
[/TD]
[TD="class: xl67, bgcolor: #D9D9D9"]0
[/TD]
[/TR]
</tbody>[/TABLE]

 

[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