Aligning Two Columns by common number
 

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.

Aligning Two Columns by common number
 

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.

--
If this posting was helpful, please click on the Yes button.
Regards,

Michael Arch.




"Andrew" wrote:

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.

Aligning Two Columns by common number
 

I meant
=Exact(A1,F1)
--
If this posting was helpful, please click on the Yes button.
Regards,

Michael Arch.




"Andrew" wrote:

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.