google sheets - is it possible to match only the “duplicate values” from a column?

0
votes

https://docs.google.com/spreadsheets/d/1H8EdAJ3PXzntWvk3jygo8DRRi-Ej4IVEnG0kG6Zj6Og/edit?usp=sharing

in the example sheet above, I would like to populate column H only the duplicate serial numbers found in column E. Column F has formula that represents wether the value in E is duplicate with True/False - I'm assuming there is a way to use the TRUE value to index and match them over to column H?

1
google-sheetsgoogle-sheets-formula
Something like =UNIQUE(FILTER(E2:E,COUNTIFS(E2:E,E2:E)>1))? Not sure though... – JvdV
hmm will give it a shot, thx. – Vvega

1 Answers

3
votes

I think this should work for you. You don't need the helper column.

=FILTER(E:E,E:E<>"",COUNTIF(E:E,E:E)>1)