Module 6: How to Search PubChem for Chemical Information (Part 2) | DivCHED CCCE: Cheminformatics OLCC

? [Note that a compound may have multiple EC50 values determined from different experiments (likely under different experimental conditions)

There are two ways to get rid of duplicates. You can simply paste the CIDs into the pubchem search, and search, I think this requires Chrome.

or

You can go to Data/data tools in excel, and choose the "Remove duplicates" tool

Item URL: 
https://hypothes.is/a/60jP5hMtEeeKGUvL5ssZdA