put yes depending on a open balance

[mark692]

hi guys i have 2 problems on my table

1. on column C i want to put a formula that will indicate yes if a the group code code has an open balance like this

	A	B	C
1	Open Balance	Group Code	With Balance
2	50.00	1	YES
3	50.00	1	YES
4	-	1	YES
5	-	1	YES
6	-	2	No
7	-	2	No
8	-	2	No
9	10.00	3	YES
10	10.00	3	YES

<tbody>
</tbody>

Sheet1
​

2. On column C 1 want to put a word "Dont delete" if Column B with the same group code has a word "Don't" like this:

	A	B	C
1	Group Code	Type	Remarks
2	1	Don’t	Don’t delete
3	1	delete	Don’t delete
4	1	delete	Don’t delete
5	1	Don’t	Don’t delete
6	2	Delete	Delete
7	2	Delete	Delete
8	2	Delete	Delete

<colgroup><col style="width: 25pxpx"><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>

Sheet2​

thanks!

 

[Youngdand]

Sorry didn't read properly! gimmie 5 mins

1. =IF(SUMIF($C$2:$C$10,C2,$B$2:$B$10)>0,"yes","no")

 

[mark692]

Sorry didn't read properly! gimmie 5 mins

1. =IF(SUMIF($C$2:$C$10,C2,$B$2:$B$10)>0,"yes","no")

not working sir

 

[jtakw]

Hi,

Will these work for you:

Book1
	A	B	C
1	Open Balance	Group Code	With Balance
2	50	1	YES
3	50	1	YES
4	-	1	YES
5	-	1	YES
6	-	2	NO
7	-	2	NO
8	-	2	NO
9	10	3	YES
10	10	3	YES
Sheet2

Cell Formulas
Range	Formula
C2	=IF(COUNTIFS(B$2:B$10,B2,A$2:A$10,">0")>0,"YES","NO")

Book1
	A	B	C
1	Group Code	Type	Remarks
2	1	Don't	Don't Delete
3	1	delete	Don't Delete
4	1	delete	Don't Delete
5	1	Don't	Don't Delete
6	2	Delete	Delete
7	2	Delete	Delete
8	2	Delete	Delete
Sheet3

Cell Formulas
Range	Formula
C2	=IF(COUNTIFS(A$2:A$8,A2,B$2:B$8,"Don't")>0,"Don't Delete","Delete")

 

[Youngdand]

Sorry didn't read properly! gimmie 5 mins

1. =IF(SUMIF($C$2:$C$10,C2,$B$2:$B$10)>0,"yes","no")

Just the range, when i copied your sheets, the row numbers were in column A, =IF(SUMIF($B$2:$B$10,B2,$A$2:$A$10)>0,"yes","no") would work fine.