Aligning Two Columns by common number

A

Andrew

I am trying to sort two columns in the same worksheet. Column A is my item #
from a cash register item table. Column F is my item # from my inventory.
There are discrepancies between the two (Column A has an item # 6, and Column
F doesn't, etc.). I am trying to sort them so Column A and Column F matches
align, and the non-matches are put at the bottom or on a separate worksheet.
 
M

Michael

Add a third column and place this formula in it:
=Exact(A1,B1)
This will return true or false, then you can sort on ascending or descending
on true or false to align them.
 
Top