Sort two columns so that matching numbers line up in rows

Hello,

I'm new to the forum so please forgive any protocol or category violation that I may have committed. I am fairly handy with Excel and am generally good with doing web searches to find my solutions. However, this time I have one that I can't figure out. It is a sorting issue.

I have three columns containing many numbers that are each sorted numerically. In some cases, numbers in the columns are unique and do not appear in the other two columns. In other cases, numbers may appear in two, or even all three of the other columns. I am able to visually identify these numbers by using "Conditional Formatting", "Highlight Cells Rules", and then "Duplicate Values..." This of course changes any cells with duplicate values to pink. Therefore, I am able to at least visually see which cells have unique numbers because they remain white.

My issue is that I would like to have all three columns sorted numerically so that any numbers that match in two or more columns line up with each other in the same row. I want numbers that are unique line up to blank cells in the other columns.

I have attached a simple example of what I am trying to accomplish to this post. In the "Before Custom Sort" columns, I show a basic example of the kind of data that I have. I did a "Duplicate Values..." to it so you can easily see the pink matching cells. In the "After Custom Sort" columns, I have manually arranged them to demonstrate my desired results. I believe this spreadsheet explains itself.

Is there any way I can accomplish this? I will add here that I am not at all versed in VBS, so I am not able to any sort of scripting to solve my issue. I am hoping that there is a straightforward solution to my problem by using functions found in the Ribbon.

Thank you for any assistance you can provide.

-Patrick

I have attached my real data. I hope this helps. Thank you for your assistance.

-Patrick

I just realized that my comment in cell D4 is incorrect. It says "A while cell indicates a missing number". It should say "A white cell indicates a unique number". Sorry for the confusion.

Give this a look. Thank you.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Would something like an XLOOKUP help?

Array formula.

Formula:

Please Login or Register  to view this content.