Forum Discussion
How to find values that repeat x times
Hello to everybody! Help me figure out if it is possible to find cells in Excel using built-in tools or functions that are repeated x times. I have a large book of clients and am currently workin...
=TEXTJOIN(", ",,DROP(REDUCE("",SEQUENCE(ROWS(UNIQUE(A1:A15))),
LAMBDA(x,y,VSTACK(x,IF(COUNTIF(A1:A15,INDEX(UNIQUE(A1:A15),y))=C1,
INDEX(UNIQUE(A1:A15),y),"")))),1))
With Office 365 or Excel for the web you can apply this formula.