Using Match To Detect Duplicate Record

Hi All,

There are 100 records in column A,B,C respectively.

e.g)

For row3,
if A3 can be found in A1:A100-A3
then check
if B3 can be found in B1:A100-B3
then check
if C3 can be found in C1:C100-C3
then D3 returns "YES" if all true
Else
D3 returns "No"

Now, im using =IF(ISERROR(MATCH(A3,$A$1:$A$100-A3,0)),"No","Yes") for checking A3 and it works fine,,

but i don't know how to keep on checking B3, C3

Thanks for any help.

Hi and welcome to the forum

1st, your ranges look very strange, what does the "-A3" do at the end of the "A1:A100-A3" do/mean? Ranges are normally the top-left:bottom-right cell references.

2nd, I think it would help if you provided a sample workbook, showing samples of the data you are working with, and what your expected outcome would be?
To attach a file to your post,
click advanced (next to quick post),
scroll down until you see "manage file",
click that and select "add files" (top right corner).
click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"

Once the upload is completed the file name will appear below the input boxes in this window.
You can then close the window to return to the new post screen.

Thanks for the file. Try this, copied down...
=IF(COUNTIFS($A$2:$A$14,A2,$B$2:$B$14,B2,$C$2:$C$14,C2)>1,"YES","NO")

I have never heard of "BTW, Isn't A1:A100-A3 = "From Cell A1 to A100 except A3 ???"", but that doesnt mean you are wrong lol