Finding equal cells in 2 columns

[gunrajd]

I want to look at the cells in two columns. Find in both where one cell in one column is the exact value of a cell in another. I want to then have these columns lined up and then have the equal cells found aligned first in decending order. Exactly as follows:

Column A's entries line up with Column B if they have the same value, The entries found in Column A without an equal value in B align to a blank space.

Assumptions: All of B will be in A. A may not match always, therefore A will be longer than B and the non matches in A will align with a blank in B because once B is matched the rest is empty, owing to the fact that B is a subset of A.

Example:

Column A | Column B
1 1
2 3
3 5
4
5


End result

Colu

Column A | Column B
1 1
2
3 3
4
5 5

 

[misterstick]

1. sort column a
2. fill column c with the following formula (where n is the last row in colunm B):

=if(isna(vlookup(A1, $B$1:$B$n, 1, FALSE)), "", vlookup(A1, $B$1:$B$n, 1, FALSE))

mr s. <