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
Open Balance	Group Code	With Balance
YES
YES
YES
YES
No
No
No
YES
YES

<tbody>
[TD="align: center"]1[/TD]

[TD="align: center"]2[/TD]
[TD="align: right"] 50.00[/TD]
[TD="align: right"]1[/TD]

[TD="align: center"]3[/TD]
[TD="align: right"] 50.00[/TD]
[TD="align: right"]1[/TD]

[TD="align: center"]4[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"]1[/TD]

[TD="align: center"]5[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"]1[/TD]

[TD="align: center"]6[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"]2[/TD]

[TD="align: center"]7[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"]2[/TD]

[TD="align: center"]8[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"]2[/TD]

[TD="align: center"]9[/TD]
[TD="align: right"] 10.00[/TD]
[TD="align: right"]3[/TD]

[TD="align: center"]10[/TD]
[TD="align: right"] 10.00[/TD]
[TD="align: right"]3[/TD]

</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
Group Code	Type	Remarks
Don’t	Don’t delete
delete	Don’t delete
delete	Don’t delete
Don’t	Don’t delete
Delete	Delete
Delete	Delete
Delete	Delete

<colgroup><col style="width: 25pxpx"><col><col><col></colgroup><thead>
</thead><tbody>
[TD="align: center"]1[/TD]

[TD="align: center"]2[/TD]
[TD="align: right"]1[/TD]

[TD="align: center"]3[/TD]
[TD="align: right"]1[/TD]

[TD="align: center"]4[/TD]
[TD="align: right"]1[/TD]

[TD="align: center"]5[/TD]
[TD="align: right"]1[/TD]

[TD="align: center"]6[/TD]
[TD="align: right"]2[/TD]

[TD="align: center"]7[/TD]
[TD="align: right"]2[/TD]

[TD="align: center"]8[/TD]
[TD="align: right"]2[/TD]

</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.