Mark Duplicate (Leaving First One) on Multiple Column Comparison

[gnaga]

Hi,

I need a formula or VBA solution to compare data in the first five columns. If all values in the first five columns are same then leave the first appearance of such row then mark the remaining such row as "DUPLICATE" in the last column. Example Data given below. I need your expertise help to achive this.

Book1
	C	D	E	F	G	H	I
4	Date	Time	Main	Sub1	Sub2	Value	Remarks
5	01-May-22	4:00:00 PM	Apple	Juice	Mon	2
6	01-May-22	4:00:00 PM	Apple	Juice	Mon	2.1	Duplicate
7	01-May-22	4:00:00 PM	Apple	Salad	Mon	1.9
8	02-May-22	4:00:00 PM	Orange	Juice	Mon	3
9	02-May-22	4:00:00 PM	Orange	Juice	Mon	5	Duplicate
10	02-May-22	4:00:00 PM	Orange	Juice	Mon	3.7	Duplicate
11	04-May-22	2:30:00 PM	Grape	Juice	Mon	8
12	04-May-22	2:45:00 PM	Grape	Juice	Mon	2.7
13	05-May-22	2:15:00 PM	Mango	Juice	Mon	1
14	06-May-22	2:15:00 PM	Mango	Juice	Mon	6
Sheet1

Cell Formulas
Range	Formula
I6,I9:I10	I6	="Duplicate"

 

[Fluff]

How about

=IF(COUNTIFS(C$5:C5,C5,D$5:D5,D5,E$5:E5,E5,F$5:F5,F5,G$5:G5,G5)>1,"Duplicate","")

 

[gnaga]

Thank you so much Fluff . It works Fine.

 

[Fluff]

Glad to help & thanks for the feedback.