How do I display x,y coordinates without displaying duplicate x,y coordinates?

[arthurz11]

 

[Fluff]

Glad we could help & thanks for the feedback.
FWIW a slightly shorter version

=LET(f,FILTER(A2:J2,A2:J2<>""),s,SEQUENCE(COLUMNS(f)/2,,0),u,UNIQUE(INDEX(f,,s*2+{1,2})),ss,SEQUENCE(,COUNT(u),0),INDEX(u,INT(ss/2)+1,MOD(ss,2)+1))

 

[arthurz11]

Glad we could help & thanks for the feedback.
FWIW a slightly shorter version

=LET(f,FILTER(A2:J2,A2:J2<>""),s,SEQUENCE(COLUMNS(f)/2,,0),u,UNIQUE(INDEX(f,,s*2+{1,2})),ss,SEQUENCE(,COUNT(u),0),INDEX(u,INT(ss/2)+1,MOD(ss,2)+1))

FYI, The formula worked great! HOWEVER, I encountered where there were no data (x,y coordinate) at all. The results was #CALC. So what do I add at the end of this formula so it gives me a blank instead #CALC? Please help again. =LET(f,FILTER(A2:J2,A2:J2<>""),s,SEQUENCE(COLUMNS(f)/2,,0),u,UNIQUE(INDEX(f,,s*2+{1,2})),ss,SEQUENCE(COUNT(u),,0),TRANSPOSE(INDEX(u,INT(ss/2)+1,MOD(ss,2)+1)))

 

[Fluff]

How about

=LET(f,FILTER(A2:J2,A2:J2<>""),s,SEQUENCE(COLUMNS(f)/2,,0),u,UNIQUE(INDEX(f,,s*2+{1,2})),ss,SEQUENCE(,COUNT(u),0),IFERROR(INDEX(u,INT(ss/2)+1,MOD(ss,2)+1),""))

 

[arthurz11]

How about

=LET(f,FILTER(A2:J2,A2:J2<>""),s,SEQUENCE(COLUMNS(f)/2,,0),u,UNIQUE(INDEX(f,,s*2+{1,2})),ss,SEQUENCE(,COUNT(u),0),IFERROR(INDEX(u,INT(ss/2)+1,MOD(ss,2)+1),""))

Thank you soo much for your help. I know that the formula is for one row and it work great! Reference to Post #1. How would I write the formula in cell L2 to check for duplicates for the entire range A2:J5? Just in case there are duplicates of x,y coordinates on another row? For example if cell I5 is -2 and cell J5 is -7, this will be an x,y coordinates of -2,-7 in row four and not just in row one. The formula in L5 of row four will not recognize -2,-7 as a duplicate from row one so -2,-7 will be displayed twice, in row one and on row four.

 

[Fluff]

As this is a different question it needs a new thread. Thanks

 

[arthurz11]

As this is a different question it needs a new thread. Thanks

Ok