I have a large spreadsheet with duplicate entries adjacent on 2 rows is there a formula for this they are marriages and need pairing up as you can see from the reference numbers on right side are the same that I have edited. They are in pairs with the same reference...