Programming

Need excel file/program with following headers: Order # Supplier NDC Description Strength Size Unit Price Pkg Price Category Mfgr Compares To Expiration Date Actions Need capability to add headers. I need to be able to paste several different files into the spread sheet and under the NDC column Have it highlight when the same NDC appears more than once. So if 378052393 appears 2 or more items it would be highlighted (could be any color) Order # Supplier NDC Description Strength Size Pkg Price Category Mfgr Compares To Expiration Date Actions T3601785 TopRx 378052393 BISOPROLOL FUM 10 MG TAB 10 MG 30 $3.00 Generic Unichem Zebeta 10 10/31/2020 G678291 Gmen 378052393 BISOPROLOL FUM 10 MG TAB 10 MG 30 $3.00 Generic Unichem Zebeta 10 10/31/2020 Currently in EXCEL you can chose the option to remove duplicates. But it still leaves one in the file. Need capability to remove duplicates. So I could check boxes for 2 or more of the columns shown above and any products that share the same information would be completely removed. After we remove the exact duplicates that would leave a list of products many of which could have the NDC highlighted because the NDC appears more than once. Need to be able to identify where the differences are with the products that have the same NDC So highlight the differences Order # Supplier NDC Description Strength Size Pkg Price Category Mfgr Compares To Expiration Date Actions T3601785 TopRx 378052393 BISOPROLOL FUM 10 MG TAB 10 MG 30 $3.00 Generic Unichem Zebeta 10 10/31/2020 G678291 TopRx 378052393 BISOPROLOL FUM 10 MG TAB 10 MG 30 $2.99 Generic Unichem Zebeta 10 1/31/2022 Few more possible bells and whistles but this is a good starting point.