9.13 Filter by number of repetitions

 

The following table lists the sales data of the top 5 products by monthly sales:

imagepng

Find out the data of products that appears three or more times:

=spl("=E(?1).group(ProductName).select(~.len()>2).conj()",A1:D21)

imagepng


https://c.scudata.com/article/1651916536524
https://c.scudata.com/article/1656036826376
https://c.scudata.com/article/1656138724409