formula to fill column based on group condition

[bettlejus]

Hi,

I have the sheet bellow:

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Product[/TD]
[TD]Value[/TD]
[TD]Indication[/TD]
[/TR]
[TR]
[TD]Apple[/TD]
[TD]50[/TD]
[TD]TRUE[/TD]
[/TR]
[TR]
[TD]Apple[/TD]
[TD]50[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Cherries[/TD]
[TD]20[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Cherries[/TD]
[TD]20[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Bananas[/TD]
[TD]45[/TD]
[TD]TRUE[/TD]
[/TR]
[TR]
[TD]Bananas[/TD]
[TD]45[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Bananas[/TD]
[TD]45[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]


And I want the following result:


[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Product[/TD]
[TD]Value[/TD]
[TD]Indication[/TD]
[/TR]
[TR]
[TD]Apple[/TD]
[TD]50[/TD]
[TD]TRUE[/TD]
[/TR]
[TR]
[TD]Apple[/TD]
[TD]50[/TD]
[TD]TRUE[/TD]
[/TR]
[TR]
[TD]Cherries[/TD]
[TD]20[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Cherries[/TD]
[TD]20[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Bananas[/TD]
[TD]45[/TD]
[TD]TRUE[/TD]
[/TR]
[TR]
[TD]Bananas[/TD]
[TD]45[/TD]
[TD]TRUE[/TD]
[/TR]
[TR]
[TD]Bananas[/TD]
[TD]45[/TD]
[TD]TRUE[/TD]
[/TR]
</tbody>[/TABLE]


To fill the column C with value found only on first product but only if the value is a specific text, in this case "TRUE".

Can I do this with a formula?

Thank you!

 

[FlexMind]

Hi!
With formulas you can do what you want in the new column only:
https://yadi.sk/i/-oNivKX_Xm5a_g

 

[bettlejus]

I cannot save the file in the link, it is ok to fill in another column, but I cannot see the solution in your link.

Thank you!

 

[Fluff]

How about

Excel 2013/2016
	A	B	C	D
1	Product	Value	Indication
2	Apple	50	TRUE	TRUE
3	Apple	50		TRUE
4	Cherries	20
5	Cherries	20
6	Bananas	45	TRUE	TRUE
7	Bananas	45		TRUE
8	Bananas	45		TRUE
Engine

Cell Formulas
Range	Formula
D2	=IF(C2<>"",C2,IF(A2=A1,D1,""))

 

[bettlejus]

How about


[TABLE="width: 85%"]
<tbody>[TR]
[TD]Worksheet Formulas[TABLE="width: 100%"]
<thead>[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]
[TH="width: 10px"]Cell[/TH]
[TH="align: left"]Formula[/TH]
[/TR]
</thead><tbody>[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]D2[/TH]
[TD="align: left"]=IF(C2<>"",C2,IF(A2=A1,D1,""))[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]

It is ok, except one thing, if my "indication" start lower than the "Product" it does not fill the first line, like this:

[TABLE="width: 500"]
<tbody>[TR]
[TD]Product[/TD]
[TD]Value[/TD]
[TD]Indication[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Bananas[/TD]
[TD]45
[/TD]
[TD][/TD]
[TD]This must be filled also with "TRUE"[/TD]
[/TR]
[TR]
[TD]Bananas[/TD]
[TD]45[/TD]
[TD]TRUE[/TD]
[TD]TRUE[/TD]
[/TR]
[TR]
[TD]Bananas[/TD]
[TD]45[/TD]
[TD][/TD]
[TD]TRUE[/TD]
[/TR]
</tbody>[/TABLE]

 

[Fluff]

Ok, how about

Excel 2013/2016
	A	B	C	D
1	Product	Value	Indication
2	Apple	50	TRUE	TRUE
3	Apple	50		TRUE
4	Cherries	20
5	Cherries	20
6	Bananas	45		TRUE
7	Bananas	45	TRUE	TRUE
8	Bananas	45		TRUE
Sheet2

Cell Formulas
Range	Formula
D2	=IF(COUNTIFS($A$2:$A$8,A2,$C$2:$C$8,"<>")>0,TRUE,"")