I have a large spreadsheet of purchased items (and their respective transaction dates) which has a number of duplicate catalog numbers. I want to get rid of the duplicate entries but only when certain other variables do not apply. Please see below...what is the easiest way to achieve this?
Here is the logic:
IF you find duplicate catalog numbers AND the following rules do NOT apply THEN keep the item with the most recent Transaction Date AND add up the Quantities purchased AND remove remaining duplicates
Rules:
1. Different Hospital name
2. Different Manufacturer
3. Different UOM type
Bookmarks