Values that appear more than once in different ranges

[uk747]

I currently have
=Sort(unique(vstack(B4:B10, D4:d10, f4:f10)))
Which creates a list of all values in those ranges

What I want is a list of just values that appear more than once e.g. in column b
Red
Green
Red

Column d
Yellow
Orange
Purple
Green

Column f
Purple
Blue

So the ones that appear 2 or more times should be red green and purple

Thanks

 

[hagia_sofia]

Hello, one way to do it could be:

=LET(
a,TOCOL(VSTACK(B4:B10,D4:D10,F4:F10),1),
b,TRANSPOSE(UNIQUE(a,,TRUE)),
UNIQUE(FILTER(a,NOT(BYROW(a=b,LAMBDA(x,OR(x)))))))

 

[uk747]

Thanks

 

[Peter_SSs]

A little bit shorter (also allows for no dupes)

=LET(a,TOCOL(VSTACK(B4:B10, D4:D10, F4:F10),1),UNIQUE(FILTER(a,MATCH(a,a,0)<>SEQUENCE(ROWS(a)),"None")))