Identifying & Extracting Duplicates from Multiple Columns

[maxisultan]

Hello,

I have tried finding the solution to this problem elsewhere in the forum (and all of Google) but couldn't - That said, if the solution has already been discussed, feel free to redirect me there. I am trying to identify and extract duplicate values from several columns. That is, for a spreadsheet with columns A to Z (example), I would want to compare for each column, which values are common with A - E.g., Which values does B have that are common with A, which values in C are common with A, and so on.

I can do conditional formatting one by one with a formula that identifies duplicates, but since there are many columns and I later need to extract the numbers, I would have to filter by color one by one in and copy paste the unformatted values into a new sheet or column, which is tedious. I am looking for a formula that I can copy below the columns that will essentially provide me only with the unique values.

Let me know if anybody has done this before! - Thanks for the help!

[TheCman81]

Edit: Are you only looking for duplicates that match column A?

[maxisultan]

Actually TheCman81 - I tried deleting the thread as I believe the early morning got to me and my original post has misdirection everywhere. Instead of duplicates that match, what I need are the unique values. For example, Column A has ~1000 rows. Column B-Z all have about the same (some more, some less). I ran some analysis with formulas that I found that tell me that the commonality within the values in these columns (between B to A, C to A, D to A, etc.) is about ~95%. What I need is a list of the values that comprise that other 5%. Does that make sense? It is basically the values in B to Z that do not appear in A. Later I will need to understand how often they appear in B to Z, but I believe a countif can take care of that one. Let me know what you think! Thanks!