title: Search Excel for duplicate cells
body: <p>I have data columns of an order_items table stored in Excel file. The table is about 1 million rows long and contains columns item_id, order_id, price and quantity. In addition to that, I have an Oracle database which is built so, that primary key is combined from item_id and order_id.</p>
  
  <p>When I try to import the data into an Oracle table, I get errors that the primary key is violated. Since I generated the table data randomly, then there may be some cases in million rows, where one order contains the same product multiple times.</p>
  
  <p>I'm able to sort the data by either column, but I wouldn't like to go through all those million rows by hand, so could anyone tell me what would be the easiest way to find multiple rows in excel, which have same item_id (labeled A) and order_id (labeled B) columns.</p>