Forum Discussion
How to create an autonumbering formula based on three columns
Update: Black cat on Stack Overflow gave the following formula that worked great: =MATCH(A2,UNIQUE(A$2:A2),0)&"."&MATCH(B2,UNIQUE(FILTER(B$2:B2,A2=A$2:A2)),0)&"."&MATCH(C2,UNIQUE(FILTER($C$2:$C2,A$...
=BYROW(MAP(A2:C14,LAMBDA(x,IF(COLUMN(x)=1,MATCH(x,UNIQUE(A2:A14),),"."&MATCH(x,UNIQUE(FILTER(OFFSET(x,2-ROW(x),):x,MMULT(--(A2:OFFSET(x,,-1)=OFFSET(x,,1-COLUMN(x),,COLUMN(x)-1)),SEQUENCE(COLUMN(x)-1)^0)=COLUMN(x)-1)),)))),CONCAT)
Thanks for the formula, unfortunately, it gives me a #NAME? error and I can't seem to resolve it