Hans Knudsen
New Member
I need to ensure that only certain ID's are entered and that a given ID is entered only once.
Pleas see the attached workbook.
Pleas see the attached workbook.
Attachments
-
11.4 KB Views: 9
(D2=ID)
?= LET(
otherIDs, IF(Table1[Seq]<>Table1[@Seq], Table1[ID]),
available, ISERROR(XMATCH(ID, otherIDs)),
IF(ISERROR(Table1[@Seq]), "", TRANSPOSE(FILTER(ID, available))) )