Find if there are redundancies in 4 different columns

[Seabastein]

Hello,

I would like to know if there is any way to know if the same value can be found on the same line across 4 different columns.

It doesn't matter what the value is (it is only going to be numbers) and in which column it is, as long as this value is present at least twice (example below). I couldn't find any formula that does the job.

 

And is it a lot more complicate to return the value as the example below? 

Thank you so much in advance for taking the time to help me, I appreciate it !

Greetings, 

Seb

[Seabastein]

Thank you so much Samarth, it works well

[Samarth_18 · Accepted solution]

Hi @Seabastein ,

You could try this:-

Column = 
SWITCH(TRUE(),
('Table (3)'[Column1] = 'Table (3)'[Column2] || 'Table (3)'[Column1] = 'Table (3)'[Column3] || 'Table (3)'[Column1] = 'Table (3)'[Column4]),'Table (3)'[Column1],
('Table (3)'[Column2] = 'Table (3)'[Column4]) || ('Table (3)'[Column2] = 'Table (3)'[Column3]),'Table (3)'[Column2],
('Table (3)'[Column3] = 'Table (3)'[Column4]),'Table (3)'[Column3])

Output:-

Thanks,

Samarth