Is it the Excel spreadsheet you want to check for duplicates or the Access table?

Excel has a built-in function on the Data tab called Remove Duplicates and you just select which columns you want to check for duplicates, e.g. Job Ref, and it will do it for you.