Formula to remove duplicates based on several criteria

[ybr_15]

I want to remove duplicate values in column D (Estimate) so that the result is like in column G (Result). The criteria are: "If there is a row of the same values in column B (Category), column C (Size), and column F (Material) then the value is 0 (marked in orange)". I still can't get the formula. Can I be helped? Thank you...

Book2
	B	C	D	E	F	G
2	CATEGORY	SIZE	ESTIMATE	%	MATERIAL	RESULT
3	OTHERS	14.8 X 21	14,500	102%	-	14,500
4	OTHERS	14.8 X 21	1,000	118%	AC 210, 65 X 100	1,000
5	OTHERS	14.8 X 21	14,500	102%	-	-
6	OTHERS	15 X 19.5	3,917	38%	-	3,917
7	OTHERS	21 X 29.7	119,700	103%	-	119,700
8	OTHERS	21 X 29.7	119,700	103%	-	-
9	OTHERS	21 X 29.7	1,000	152%	AC 190, 65 X 100	1,000
10	OTHERS	21 X 29.7	119,700	103%	-	-
11	OTHERS	21 X 29.7	119,700	103%	-	-
12	OTHERS	23 X 33.5	19,180	92%	-	19,180
13	OTHERS	38.5 X 52	34,891	100%	-	34,891
Sheet1

 

[Takae]

Hope this helps.
G3=IF(COUNTIFS($B$3:B3,B3,$C$3:C3,C3,,$D$3:D3,D3$F$3:F3,F3)>1,0,D3)

 

[ybr_15]

Hope this helps.
G3=IF(COUNTIFS($B$3:B3,B3,$C$3:C3,C3,,$D$3:D3,D3$F$3:F3,F3)>1,0,D3)

Hi, Takae
Yes, it works. Thank you... There is a slight typo, here my edited: =IF(COUNTIFS($B$3:B3,B3,$C$3:C3,C3,$D$3:D3,D3,$F$3:F3,F3)>1,0,D3)

 

[Takae]

Thank you!