All data is in thenamed rangedata(B5:B16).
Notice each of these values occurs at least 2 times indata.
The output from FILTER is dynamic.
If source data or criteria change, FILTER will return a new set of results.
COUNTIF can be used to count…
FILTER to show duplicate values
To list duplicate values in a set of data based on a threshold count, you can use a formula based on FILTER, UNIQUE, and the COUNTIF function. In the example shown, the formula in F5 is: =UNIQUE(FILTER(data,COUNTIF(data,data)>=D5)) This formula lists the duplicate values in the named range data (B5:B16) using the "Min count" value in D5 as a minimum threshold. In other words, a value must occur in the data at least as many times as the number in D5. The result from the formula is dynamic and will change if the number in D5 is changed.
