I've tried this without success but I am looking for a data validation in a separate tab to show only unique values among a list of approximately 200 entries starting in Cell M5 of a Tab called "New Bid" and ending at M200 . I've tried Offset formulas with CountA in them according to a video I watched but it is not working. How can I do this?