Large Data base, need to sift through and find duplicates to find x.

Hey guys,


Ill just get right to the point. I have a database of about 400,000 lines. My goal is to fill in all the commodity codes. The rows in the above picture with N/A can be filled in with the same commodity code since they both share the same description.

My question is, how can I sort or build a table that will only show me the following:
-contains the same item description
-has 1 commodity code filled out
-has 1 N/A
I want to be able to see only rows with those conditions so that I am not sifting through the others.

I really don’t want to have to sift through the entire database and I am just not seeing the answer.

thanks,

Tyler G