Find duplicates based on Col A and Col B

[fdiddy]

Hi All,
In the below example i need to base duplicates on Col A & Col B and then if it is a duplicate, mark it with Germany in this case but this value will be different in a larger dataset.

A macro would be ideal if its possible - thanks all

Country	SKU Type	SKU Num	SKU Ex. Name
Germany	A. CPU	12345-A	Intel 9th Gen Core i5-9400H
Germany	B. RAM	12345-B	8GB, 1x8GB
Germany	C. Storage	12345-C	256GB SSD
Germany	C. Storage	12345-D	No Additional Hard Drive
Germany	D. Battery	12345-E	68Whr
Germany	E. Screen	12345-F	15.6" FHD Anti-Glare Non-touch
Germany	F. WLAN Card	12345-G	Intel Dual Band Wireless AC 9560
Germany	F. WLAN Card	12345-H	Drivers for Intel 9560
Germany	G. OS	12345-I	Windows 10 Pro
Germany	G. OS	12345-J	No Media
Germany	J. Keyboard	12345-K	Internal German
Germany	K. Palmrest / Fingerprint	12345-L	Palmrest Thunder

Country	SKU Type	SKU Num	SKU Ex. Name	Duplicate Record
Germany	A. CPU	12345-A	Intel 9th Gen Core i5-9400H
Germany	B. RAM	12345-B	8GB, 1x8GB
Germany	C. Storage	12345-C	256GB SSD	Germany
Germany	C. Storage	12345-D	No Additional Hard Drive	Germany
Germany	D. Battery	12345-E	68Whr
Germany	E. Screen	12345-F	15.6" FHD Anti-Glare Non-touch
Germany	F. WLAN Card	12345-G	Intel Dual Band Wireless AC 9560	Germany
Germany	F. WLAN Card	12345-H	Drivers for Intel 9560	Germany
Germany	G. OS	12345-I	Windows 10 Pro	Germany
Germany	G. OS	12345-J	No Media	Germany
Germany	J. Keyboard	12345-K	Internal German
Germany	K. Palmrest / Fingerprint	12345-L	Palmrest Thunder

 

[etaf]

=countifs(A:A,A2,B:B,B2)>1

=IF( countifs(A:A,A2,B:B,B2)>1, "Germany","")
OR if you want A to be the output
=IF( countifs(A:A,A2,B:B,B2)>1, A2,"")

 

[fdiddy]

Excellent - worked a treat !! Thank you

 

[etaf]

you are welcome