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


esProc Desktop and Excel Processing
9.12 Deduplication of row-based data - by whole row - keeping order
9.14 Delete data that can be paired