How compare 4 columns

I'm working with a table in Excel. Here is an example of the Sheet:

A B C D
al id id id
df id desc desc
df id id desc
df id id id
ff desc id desc
ff desc id desc
al id id id
al id id desc
mn desc desc desc
mn desc desc desc
ff desc id desc

First of all, I have to compare the column A with duplicate values and you will get a table of columns A B C and D. With that table, I have to compare de columns B C and D at once.

Later, I have to create a new column where I have to put 1 if they all match, 0 otherwise.

How can I do that in Excel with functions??

Here is an example:

First row with values: al id id id. There are to compare with all rows in the column A and save each row that that is matched. In this case:

A B C D
al id id id
al id id desc

So, this is what we get:

A B C D
al id id id
al id id id
al id id desc

Therefore, we have to compare each row in the same column. So, B1=B2, B1=B3, B2=B3. As the last column is not equal, you have to create a new column with the value 0 because there is not a complete coincidences.

Another examples, for: ff desc id desc. There are to compare with all rows in the column A and save each row that that is matched. In this case:

A B C D
ff desc id desc
ff desc id desc

So, this is what we get:

A B C D
ff desc id desc
ff desc id desc
ff desc id desc

As the columns match, in the new column would have to be 1.

Final result with the two examples:

E F
al 0
ff 1

where 0 means that there are mismatched rows, 1 for equals.

I hope I have explained well.

Any questions, let me know.

Match Unique Columns

Edit

• If you prefer the 1s and 0s, replace the "Yes"-es and "No"-s with them.

=LET(d,A2:D12,uc,1,y,"Yes",n,"No",
    ud,INDEX(d,,uc),u,UNIQUE(ud),um,XMATCH(ud,u),
    us,XMATCH(SEQUENCE(ROWS(u)),um),
    ui,INDEX(d,us,SEQUENCE(,COLUMNS(d))),
    nc,BYROW(u,
    LAMBDA(r,ROWS(UNIQUE(FILTER(d,ud=r)))=1)),
HSTACK(ui,IF(nc,y,n)))

=LET(d,A2:D12,uc,1,y,"Yes",n,"No",
    ud,INDEX(d,,uc),u,UNIQUE(ud),
    nc,BYROW(u,
    LAMBDA(r,ROWS(UNIQUE(FILTER(d,ud=r)))=1)),
HSTACK(u,IF(nc,y,n)))

• Note that cell B12 is different than in the previous screenshot.

Initial Post

=LET(d,A2:D12,uc,1,
    ud,INDEX(d,,uc),u,UNIQUE(ud),um,XMATCH(ud,u),
    us,XMATCH(SEQUENCE(ROWS(u)),um),
    ui,INDEX(d,us,SEQUENCE(,COLUMNS(d))),
    nc,BYROW(DROP(ui,,1),
        LAMBDA(r,--(COLUMNS(UNIQUE(r,1))=1))),
HSTACK(ui,nc))

One option would be:

Formula in F1:

=LET(x,UNIQUE(A1:A11),HSTACK(x,--MAP(x,LAMBDA(y,ROWS(UNIQUE(FILTER(B1:D11,A1:A11=y)))=1))))