View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
blaylock blaylock is offline
external usenet poster
 
Posts: 2
Default Sort and Match like Items in 2 Columns

The purpose of my project is to reconcile financial information. I have 2
colums of numbers...while most numbers in column A will match those in column
B, I do have some that do not match or are missing...must be out of balance :
) My objective is to sort the two columns in a manner with the data in both
columns match up. If there are mismatched numbers or missing numbers in one
column/row, then I want the alternating column/row to be left blank.