View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Andrew Andrew is offline
external usenet poster
 
Posts: 358
Default 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.