Excel find which group of nunbers repeating in multiple columnes

[exoterikos]

I have 4 columnes with simple values. 31,42,44 appears in every columne. But this is a small sample of data . I need to work with much bigger data.
Is there any formula to find which numbers appears simultaneously on all columnes?

 

[AliGW]

Cross-posted here: https://www.excelforum.com/excel-fo...f-nunbers-repeating-in-multiple-columnes.html
and here: https://stackoverflow.com/questions...oup-of-nunbers-repeating-in-multiple-columnes
and here: https://chandoo.org/forum/threads/e...nunbers-repeating-in-multiple-columnes.48529/
and here: https://www.mrexcel.com/board/threa...nbers-repeating-in-multiple-columnes.1212230/

You must provide links when you do this (same on all forums). Here's why: https://excelguru.ca/a-message-to-forum-cross-posters/