I have data that looks like this:
ID. Code
12345. 2391
12345. 2392
56789. 2391
56789. 2391
I'm trying to figure out how to bring in just those with IDs that have BOTH 2391 and 2392 not just one or the other. How would I do that in Access? And if anyone knows, how would I do it in Excel as well?
Thank you