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
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