Forum Discussion
Formula to repeat dynamic patterns
Thank you in advance. Is there a formula I can use to generate the patter in column D based on the duplicate data in columns A-C? For example, I need to enter "Y" 12 times after "N" if there are 12 ...
Yes but a better more complete explanation and sample sheet would be helpful. Based on what you said it could be starting in D2:
=IF(CONCAT(A1:C1)=CONCAT(A2:C2), "Y", "N")
and then fill down.
if instead any repeat should be marked "Y" then maybe:
=IF(ISNUMBER(XMATCH(A2 & B2 & C2, $A$1:$A1 & $B$1:$B1 & $C$1:$C1)), "Y", "N")
or
=IF( SUM((A2=A$1:A1) * (B2=B$1:B1) * (C2=C$1:C1)), "Y", "N" )
and then fill down
you could also put the above into a BYROW() or SCAN() dynamic array formula