Excel 2007 instructions to find duplicate shipping values:
Highlight column (Order ID) and then select in the ‘Home’ tab Conditional Formatting > Highlight cell rules > Duplicate Values
Sort your column to make sure that excel is picking up your duplicate values correctly. It will highlight all duplicates in red, it is best if you filter by order number and expand the selection.
You can then trawl though and zero your duplicate shipping entries.
Simple, and no excel formulas needed.
